Duncan has attended:
Excel Intermediate course
Excel Advanced course
V Look Up
I have 2 spreadsheets and I want to use a vlookup to take information from one column in one spreadsheet and populate that data in another spreadsheet so it consolidates into one document
I have an employee ID as the common value in both documents. Can you provide me with instructions about how I do that?
Thanks
RE: 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