2 column list
 

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

2 column list
 

So, the price correlates with the product?

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

"Chris Whitehead" wrote:

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

2 column list
 

Use VLOOKUP. Refer the below link for help

http://www.contextures.com/xlFunctions02.html
--
If this post helps click Yes
---------------
Jacob Skaria


"Chris Whitehead" wrote:

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

2 column list
 

Thanks Guys vlookup did the trick after a bit of tweaking


Chris

"Chris Whitehead" wrote:

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