vlookup help! needed

[wylie88]

i need help on a vlookup formula for my project?

i wont to be able to type in a product code(cell B5) and the price for that product shall come up on (cell B7) from entering the product code. all of product codes are on a product database in a table, product code in cells C2-C23. and the product price is also in the product database page in cells E3-E23.

please help!


thanks.

 

[Danbrighton]

Hopefully this should help

=VLOOKUP(B5,C3:E23,3,0)

Hope this helps

 

[SteveO59L]

in b7 type =VLOOKUP(B5,C2:E23,3). Incidentally, if you use data validation on your list of products (data, validation, Allow List) with your range of product codes as the list source, it will save you typing (possibly mistyping) your product code.


HTH