1] Write the Excel VLOOKUP function Launch Microsoft Excel and make a column for the values that act as unique identifiers. We’ll call this the reference column .

This is the demonstration file referenced in How to combine Excel's VLOOKUP() function with a combo box for enhanced searching, by Susan Harkins.

Vlookup used to create an array in memory that held the full range of the table. So the smaller you can make the array, the less memory the function will use.

Are you getting any results at all? If so, what? (#n/a, 0, errors, or stuff just not matching?)<br><br>If the text is unsorted, you need to specify FALSE for the last part of the VLOOKUP equation.