Matching and adding data

[Closed]
Report
Posts
1
Registration date
Thursday September 6, 2012
Status
Member
Last seen
September 6, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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




1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Is it possible to combine the first name and last name in the sheet 2

Lets say you can you that. So in column D of sheet 2 you can have a formula
=A1 & " " & B1

then on sheet1 you can easily use vlookup as

=IF(ISERROR(MATCH(A2 & " " & B2, Sheet2!D:D,0)),"",INDIRECT("Sheet2!C" & MATCH(A2 & " " & B2, Sheet2!D:D,0)))