Vlookup

Hello Dilly

Thank you for your question.

VLOOKUP is used to extract a piece of data from a single cell within a table/list which is arranged in columns.

Briefly there are 4 parts to the function:

1. Lookup value - what you are asking Excel to find in the leftmost column of your table. This must be a unique entry/value to other entries/values in the same column.

2. Table array - the whole table/list, in which you are going to want Excel to search for data.

3. Col_index_number - the number of the column that you would like Excel to extract data from. Columns are numbered in ascending order from left to right, starting from 1.

4. Range_lookup - use false or 0 if you require an exact match to your lookup value (else Excel gives an N/A error).

Kind regards
Amanda