VLOOKUP IN EXCEL STEP BY STEP

VLOOKUP IN EXCEL STEP BY STEP

VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. The "V" stands for "vertical". Lookup values must appear in the first column of the table, with lookup columns to the right.

1. Identify a column of cells you'd like to fill with new data.
2. Select 'Function' (Fx) > VLOOKUP and insert this formula into your highlighted cell.
3. Enter the lookup value for which you want to retrieve new data.
4. Enter the table array of the spreadsheet where your desired data is located.
5. Enter the column number of the data you want Excel to return.
6. Enter your range lookup to find an exact or approximate match of your lookup value.
7. Click 'Done' (or 'Enter') and fill your new column.