PDA

View Full Version : VLookup Help



SBrooky
08-15-2012, 07:05 AM
Hello, I have two sheets; Data and Followup
In the FollowUp sheet I want it to find the ID(column B) from the same row as where the word "Check1"(column Y) exists.

I thought:
=VLOOKUP("Check1",Data!A:Y,2,FALSE)

But apparently this doesnt work. Any ideas?

xld
08-15-2012, 07:33 AM
Maybe

=INDEX(Data!B:B,MATCH("Check1",Data!Y:Y,0))

SBrooky
08-15-2012, 08:13 AM
Returns #N/A

Ive used my original formula before for a different sheet:
=VLOOKUP("Send Email",Data!A:U,2,FALSE)

Works perfectly so im confused as to why changing A:U to A:Y means it doesnt work?

SBrooky
08-15-2012, 08:33 AM
As an update ive been playing around and it only seems to be able to find things between A:W even thought im specifying to Y? odd?

SBrooky
08-15-2012, 09:00 AM
Eventually gone with:

=INDEX(Data!A2:Y200,MATCH("Check1",Data!Y2:Y200,0),2)

Seems to work fine but I really don't understand why VLOOKUP had the issue of finding things past W? Any ideas?

I would've rather used the VLOOKUP method because the index+match method doesnt make logical sense in my head, dont understand how it works if anyone could shed light on that?

Cheers,

Sam

xld
08-15-2012, 09:35 AM
VLOOKUP has to have the first column as its lookup column, not the 2nd, nt the third,..., not the 25th.

I can't see why mine didn't work, yours is overkill indexing into multiple columns.