VLOOKUP Help

[wkenddad]

Okay,

I have 2 worksheets

Worksheet "A"
Column B = Name
Column C = Unique number

Woorksheet "B"
Column A = Name
Column B = Unique number

How can I get Worksheet A, Column A (Name) to display the Worksheet B, Column A (Name) using the Unique number in Worksheet A Column B as the Lookup criteria?

This is what I've tried in cell A1 of Worksheet "A"

=VLOOKUP(B2,'Worksheet B'!$A$1:$B$2225,1,FALSE)

I've also tried it without the $
=VLOOKUP(B2,'Worksheet B'!A1:B2225,1,FALSE)

Any ideas where I'm going wrong?

 

[wkenddad]

Or would using Index be more efficient?

 

[MrKowz]

Try:

=INDEX('Worksheet B'!A:A,MATCH(C2,'Worksheet B'!B:B,0))

The problem with using VLOOKUP is that you are trying to lookup a value to the LEFT of the lookup column. VLOOKUP only has capabilities to look to the right of the lookup column (which is always the first column of the referenced table).

 

[wkenddad]

Thanks
I keep making the VLOOKUP to the left error

 

[MrKowz]

Cheers - thanks for the feedback.