Main Profile

At A Glance

Excel Magic Trick 883: OR VLOOKUP? Lookup One Thing OR Another and Get Correct Record

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htmExcel 2003 0r 2007: See 4 methods to allow a person to enter "ID Number" OR "Name" (Lookup value is one OR another thing from two differenet columns in the database) and lookup the correct Record:1. INDEX, MATCH, and CHOOSE functions in one formula (2007 version IFERROR Function) to display records horizontally2. INDEX, MATCH, and CHOOSE functions in one formula (2003 IF Function) to display records horizontally3. CHOOSE, VLOOKUP and ROWS functions in one formula (2007 version IFERROR Function) to display records vertically4. CHOOSE, VLOOKUP and ROWS functions in one formula (2003 version IF Function) to display records vertically
Length: 09:42

Contact

Questions about Excel Magic Trick 883: OR VLOOKUP? Lookup One Thing OR Another and Get Correct Record

Want more info about Excel Magic Trick 883: OR VLOOKUP? Lookup One Thing OR Another and Get Correct Record? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question