Dilly has attended:
Excel Intermediate course
Excel Advanced course
Vlookup
How to use vlookup function
RE: 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