Drop Down Menus

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!
 
F

Frank Kabel

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)
 
Top