Excel Magic Trick #27: VLOOKUP won't work: use INDEX & MATCH

Excel Magic Trick #27: VLOOKUP won't work: use INDEX & MATCH


When the VLOOKUP function does not work, see how the combination of the INDEX and MATCH function could be the answer! Using Data Validation, and the INDEX and MATCH function you will see how to do a lookup with backward compatibility! Learn about boomerangs too!
From:
ExcelIsFun
Views:
21081

36
ratings
Time:
05:11
More in
Science & Technology