V Look Up

Hi Duncan

Thanks for your question.

The structure of the VLOOKUP function is:

=VLOOKUP(lookup value,lookup table,column index number,range lookup)

Column index number is the column you want to return your information from - you need to count columns from left to right in your lookup table 1,2,3 until you get to the column you want to return the info from.

Range lookup specifies whether it is an approximate or exact VLOOKUP.

Try using the formulas below (you will need to substitute some parts with your own references):
Column A - list of employee IDS

Column B =VLOOKUP(A1,employeetable1,2,0) -- where column 2 refers to eg employee names in your employeetable1

Column C =VLOOKUP(A1,employeetable2,3,0) -- where column 3 refers to eg employee locations in your employeetable2

Let me know if you need any more help.

Kind Regards,

Sarah
Excel Trainer