I guess changing the formula to
=VLOOKUP(A1,A5:B8,2, FALSE)
will work fine.


gedburnell yazmis:
I'm creating a spreadsheet that will return the full name of aBeer
product by entering a four character abbreviated code.

See example below:
A B
1 W40Q
2
3
4
5 JSSK JOE BLOGGS BITTER
6 W40Q ASDA DRAUGHT BITTER
7 W30C 3.0% ASDA BEST BITTER
8 W40C 4.0% ASDA BITTER

=VLOOKUP(A1,A5:B8,2, TRUE)

When I enter W30C in cell A1, I should get "3.0% ASDA BEST BITTER",
but instead I get "JOE BLOGGS BITTER".

Could anyone please explain why? Am I doing something wrong with
VLOOKUP?

How do I incorporate built in functions into VBA too?