Download the Excel file. INDEXB2B8MATCHA12D2D80 This can look complex and overwhelming when you first see it. Take the Index function replace our question mark with the MATCH function and you can now do the equivalent of VLOOKUPs when the key field is not in the left column.
Lookup formulas come in handy whenever you want to have Excel automatically return the price product ID address or some other associated value from a table based on some lookup value.
Using an approximate match searches for the value 1 in column A finds the largest value less than or equal to 1 in column A which is 0946 and then returns the value from column C in the same row. The MATCH type argument is fixed to 0. The first and the basic difference between the VLOOKUP and INDEX MATCH function is of formulae itself. At its simplest INDEX and MATCH can be used to replace VLOOKUP or HLOOKUP.