Metacafe Header Takeover

Excel Magic Trick #27: VLOOKUP Won't Work: Use INDEX & MATCH

Tags:
Excel Vlookup Index Match Functions Data Validation Backward Compatibility Mike Gel Girvin Highline Community Colleges
ExcelIsFun
  • Affiliate Submitter:
    ExcelIsFun
  • International International
  • Comments: 0
  • Views: 211
  • Added: 12-Mar-08

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!

  1. Categories: Science & Tech
Comments on

Excel Magic Trick #27: VLOOKUP Won't Work: Use INDEX & MATCH

0 Comments | Be the first to comment