How to Use a VLookup in Excel 2003 to Reference the Data in a CSV

1. Start Excel with a blank worksheet.
2. Click on the 'Data' menu, and select 'Import.' Select 'Text File' and navigate to where your CSV file is located.
3. Select 'Delimited' to identify the type of file. Select which row to start the import from; by default, Excel will import from the first row and work its way down. Click the 'Next' button.
4. Check the box for 'Commas' as the delimiter type on the next screen, then select 'Next.'
5. Select 'General' for the import rules; this is the most flexible option. You also have the choice of telling the import to exclude specific columns. When you've specified the import rules for each column, click 'Finish.' You'll be prompted to choose the upper left-most cell for the placed data; this defaults to cell A1. Excel will link to the CSV file, and every time Excel is re-opened, the imported file will update.
6. Press 'Ctrl End' to find the lower right most cell containing datat. If your imported file had 6 columns and 1000 rows, 'Ctrl End' would take you to cell F1000.
7. Enter the following formula in the blank cell of your choice:
=VLOOKUP(T1,A1:F1000,2,FALSE)
8. Enter the value you want to match in cell T1, and change the range of A1:F1000 to match the actual first and last cells in the VLOOKUP table range. The part of the formula with a '2' in it indicates it will return the value found in column 2; change this to reflect the column of the data you're interested in. FALSE indicates that it's looking for an exact match on the lookup value