troubleshooting Question

Why does this VLOOKUP not work?

Avatar of William C Johnson
William C JohnsonFlag for United States of America asked on
Microsoft Excel
6 Comments1 Solution115 ViewsLast Modified:
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
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros