Excel Forum

Excel Magic Trick 328: VLOOKUP Without 1st Column

See how to use VLOOKUP when you do not have a first column to use for lookup. Also see how to make the table range dynamic for the VLOOKUP function. See Excel 2003 List and Excel 2007 Table feature for dynamic ranges for VLOOKUP table and Data Validation List.

Got a Question? Ask it Here in the Forum.