To use MATCH to find an actual question mark or asterisk type first. To do this INDEX is configured with zero rows and one column. The INDEX function in Excel is fantastically flexible and powerful and youll find it in a huge.
And then INDEX use that number to figure out the position of the cell from the value column.
When we use MATCH it looks up for the value from the lookup column and return the cell number of that value. Likewise if you want an entire row you can pass either empty or 0 value for column parameter. Index Match in VBA INDEX MATCH function in VBA combination is the alternative to the VLOOKUP function in excel. The INDEX MATCH formula is the combination of two functions in Excel.