2 column list

[Chris Whitehead]

Hi

I have created a drop down list of products in sheet2 A2:A32 and prices in
B2:B32 and have a product list nicely apearing in my main sheet BUT not the
prices too

What i really want is to also have the prices apear in the next column when
i select a product

Any ideas and is this possible

 

[Sean Timmons]

So, the price correlates with the product?

How About =if(A2="","",VLOOKUP(A2,Sheet2!A:B,2,0))

 

[Jacob Skaria]

Use VLOOKUP. Refer the below link for help

http://www.contextures.com/xlFunctions02.html

 

[Chris Whitehead]

Thanks Guys vlookup did the trick after a bit of tweaking


Chris