2 column list

  • Thread starter Thread starter Chris Whitehead
  • Start date Start date
C

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
 
So, the price correlates with the product?

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