Lookup help

[pedroc]

I have column A with a data validation list with three possible products. In column B I want to display the price for each product by looking up from a range on a separate worksheet named Prices, where the three products are listed A1:A3 and the corresponding prices in B1:B3

The Function I used is as follows =Lookup(A2,Prices!$A$1:$B$3)

However this seems to not return the price for the first of my products instead returning the price for the third product whenever the first appears.

Any help at all would be much appreciated

pedroc
(excel novice)

 

[VoG]

Try

=VLOOKUP(A2,Prices!$A$1:$B$3,2,FALSE)

 

[markmzz]

I have column A with a data validation list with three possible products. In column B I want to display the price for each product by looking up from a range on a separate worksheet named Prices, where the three products are listed A1:A3 and the corresponding prices in B1:B3

The Function I used is as follows =Lookup(A2,Prices!$A$1:$B$3)

However this seems to not return the price for the first of my products instead returning the price for the third product whenever the first appears.

Any help at all would be much appreciated

pedroc
(excel novice)

Help of Excel about the function Lookup:

Important: the values in lookup_vector must be placed in ascending order: ..., -2, -1, 0, 1, 2, ..., A-Z, false, true; otherwise, lookup may not return the correct value. Uppercase and lowercase text are equivalent.

Markmzz