Link to home
Create AccountLog in
Avatar of William C Johnson
William C JohnsonFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Hi,

change your formula to this:

=IF(IFERROR(VLOOKUP(TEXT(F2,0),'WebEx Attendance'!$C$1:$I$7,5,FALSE),"NO")="NO","DID NOT TAKE TRAINING","Completed Training")

Open in new window

TEST_HD.xlsx
I think you only need this......

On Master List Sheet,
In A2
=IF(ISNUMBER(MATCH(F2,'WebEx Attendance'!C:C,0)),"Completed Training","DID NOT TAKE TRAINING")

Open in new window

and then copy down.
Avatar of Norie
Norie

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'?
Avatar of William C Johnson

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.