2 column list

  • Thread starter Chris Whitehead
  • 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
 
S

Sean Timmons

So, the price correlates with the product?

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project Center-Autolink column fields 0
Sale options on a CSV 1
Filtered drop down list 2
Use a master workbook to carry over changes to multiple workbooks 1
Excel formulation to automate values 3
How to make repeating drop-down lists? 2
Set as Default Template not working 0
Drop down list control value in vba 2

Top