Use A VLOOKUP In Excel

Steps to use VLOOKUP in Excel

• Step 1: Identify the lookup value — this is the cell or value you want to search for.
  (Example: D2)
• Step 2: Specify the table array — select the range that contains both the lookup value and the return value, then press F4 or Fn+F4 to lock the range.
• (Example: =VLOOKUP(D2,Table6,...))
• Step 3: Type the column index number — this is the number of the column (within the selected range) from which you want to retrieve data.
  (Example: Use 2 to return a value from the second column in your range.)
• Step 4: Choose the match type — use FALSE for an exact match, or TRUE (or leave blank) for an approximate match. Use FALSE if you're looking for an exact product code; use TRUE if searching in a sorted list for a close match.

Final formula structure:

=VLOOKUP=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Result: Excel will return the value from the specified column that corresponds to your lookup value.

Tip: If VLOOKUP returns #N/A, double-check that your lookup value exists in the first column of the selected range.