Drop Down Menus

  • Thread starter Thread starter aimi
  • Start date Start date
A

aimi

I am creating a spreadsheet with product name, numbers, manufacturers
etc. I created drop down menus for product numbers using dat
validation. Now I need to figure out how to make the other informatio
(product name, manufacturer, etc) display in the other cells once
select the product number. Does anyone know how to do this? Thanks!
 
Hi
probably VLOOKUP is the function you're looking for. Some assumptions
for my example:
- A1 stores the result of your product-no. validation listbox
- you have a data sheet (lets say 'product_data') which stores the
following columns (A-xx): product-no., product name, manufactor, etc.

Lets say you want to get the product name in cell B1 try entering the
following formula:
=VLOOKUP(A1,'product_data'!$A$1:$D$999,2,0)
for the manufactor try
=VLOOKUP(A1,'product_data'!$A$1:$D$999,3,0)
 
Aimi

If the table containing all your information has "product numbers" as the
first column, simply use vlookup to find the other information.

Alan
 
Back
Top