Hello,
I have a very basic knowledge of excel and am not sure if this can be done however I am informed this is the place to find out.
I have 2 sheets in the first sheet I have first names (Column A) and last names (Column B) and in the second sheet I have first names (Column A) and last names (Column B) and the name of that person's advisor (Column C). The two sheets do not have exactly the same data but there is an overlap.
I need to get the advisor of the corresponding person into the first sheet (Creating a column C as advisor name) using the data in the second sheet (Some will be blank because the person may not appear in sheet 2). I have been trying to do this for a while using the Vlookup, Match and Index function but I can't seem to get the desired result.
Sheet 1
A B C
First Name Last Name Advisor Name
(Populated) (Populated) (Empty)
Sheet 2
A B C
First Name Last Name Advisor Name
(Populated) (Populated) (Populated)
I would appreciate any help on this.
Thanks
James
Bookmarks