What to do if VLOOKUP Fails???

VLOOKUP cannot go Left…

Vlookup can help us if we have “Name of the student” & we want to have his “CTC”. Not the other way around [ Eg if we have the CTC of 470000, V lookup cannot tell us that this CTC is for Sriparna Ghosh

This is because, once we search a list using VLOOKUP, you can only return corresponding items from column at right, not at left.

Solution is the formula called Index + Match. The basic syntax of this combination is like this:

=INDEX (column with data you want,MATCH(value you are looking for, column which contains this data,0)).

Example:

1 Trackback / Pingback

  1. Use Index, Match & Large function to locate the best Salesman-ExcelJunkie.com

Leave a Reply

Your email address will not be published.


*