[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 65
  • Last Modified:

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
0
cowboywm
Asked:
cowboywm
1 Solution
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Lookup value should always be in the first column of the table_array used in the Vookup Function.
Change your table_array like this and change the column index (3) as per your requirement. If you use 3 as column index, the data from col. E will be returned if a match found.

VLOOKUP(F2,'WebEx Attendance'!$C$1:$I$7,3,FALSE)
0
 
Haris DjulicCommented:
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
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
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.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
NorieCommented:
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'?
0
 
cowboywmAuthor Commented:
Yes, this was the easiest to understand.  My reference point was pointing to the wrong cell.  Thank you all for your suggestions.
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome. Glad to help.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now