Index and match formula can lookup value in complex pa. Replace the value 5 in the INDEX function see previous example with the MATCH function see first example to lookup the salary of ID 53. I am a huge fan of INDEX MATCH combo and I have made it pretty clear many times.
Formulas are the key to getting things done in Excel.
This nested function is more flexible than VLOOKUP and can yield results faster. The following image shows the Excel definition of the MATCH function and then my simple definition. Learn Excel How to use the combination of Index and Match formula to look up a value with exact match. INDEX and MATCHClick here to learn more about this topic and other Excel formula.