How to Use Index Match Formula in Excel Mobile #shorts

Using Index Match Formula with Tables In Excel | Excel Mobile #shorts

The formula in this case was =Index([Table], MATCH(B16,[Table [Name]],0),1)

If not using a table for this, the [Table] would represent the entire range of rows and columns and anything following that would be to pinpoint the cell with the relevant information like a grid.

There are certain limitations with using VLOOKUP—the VLOOKUP function can only look up a value from left to right. This means that the column containing the value you look up should always be located to the left of the column containing the return value. Now if your spreadsheet isn't built this way, then do not use VLOOKUP. Use the combination of INDEX and MATCH functions instead.

#excel #indexmatch #excelfunctions #exceltutorial #excelmobile #verdexes #excelhelp #spreadsheets