Excel Magic Trick 1253

DESCRIPTION

Can I Make VLOOKUP Use Column Headers? Yes: Use VLOOKUP & MATCH!
Learn how to get VLOOKUP to use Column Headers for the col_index-num argument by using the MATCH function. See how to lookup employee data using VLOOKUP and MATCH functions, Also see how to use Data Validation List feature to add a drop-down to a cell.

WORKBOOKS