asked on Why does this VLOOKUP not work?
Can someone tell me why the formula in Column A of the Master List worksheet does not work? See attached file.
I expect the text in Column A to change based upon whether there was a match in Email Address between the two worksheets.
I expected to see the following result:
Action Full Name
Completed Training McCarthy, Nathan
DID NOT TAKE TRAINING Richardson, Christian
Completed Training Ross, Rachel
DID NOT TAKE TRAINING Abdullah, Mohamed
Completed Training Adrian, Matthew C
DID NOT TAKE TRAINING Alexander, Kori M
TEST.xlsx
I expect the text in Column A to change based upon whether there was a match in Email Address between the two worksheets.
I expected to see the following result:
Action Full Name
Completed Training McCarthy, Nathan
DID NOT TAKE TRAINING Richardson, Christian
Completed Training Ross, Rachel
DID NOT TAKE TRAINING Abdullah, Mohamed
Completed Training Adrian, Matthew C
DID NOT TAKE TRAINING Alexander, Kori M
TEST.xlsx
Microsoft Excel
Last Comment
Subodh Tiwari (Neeraj)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
I think you only need this......
On Master List Sheet,
In A2
On Master List Sheet,
In A2
=IF(ISNUMBER(MATCH(F2,'WebEx Attendance'!C:C,0)),"Completed Training","DID NOT TAKE TRAINING")
Do you actually want to return something from the sheet 'WebEx Attendance'?
Or do you just want to check the email addresses in column F on 'Master List' exist in column C on 'WebEx Attendance'?
Or do you just want to check the email addresses in column F on 'Master List' exist in column C on 'WebEx Attendance'?
ASKER
Yes, this was the easiest to understand. My reference point was pointing to the wrong cell. Thank you all for your suggestions.
You're welcome. Glad to help.
change your formula to this:
Open in new window
TEST_HD.xlsx