Auto-Populate based on Drop-down lists????

K

Kevin S - 34210

I have a table of data and have created a drop down list based on the first
column. I would like to be able to choose an item from the list and then have
the additional info I choose fill the next two columns. Is this possible?

Here is a sample:

Product Spec1 Spec2 Spec3 Price
A 0.5 6 RED $2.00
B 0.5 4 BLUE $4.00
C 0.6 8 GREEN $6.00
D 0.7 3 BLACK $8.00

When I choose Product A from the drop down on the "Invoice" worksheet I
created, I want the Spec1 and Price to fill the next two columns...

Is this even remotely possible?

Thank you in advance for your time and effort in this matter.

Kevin
 
D

Domenic

B10: =VLOOKUP(A10,A2:E5,2,0)

C10: =VLOOKUP(A10,A2:E5,5,0)

....where A10 contains your dropdown list.

Alternatively...

1) Select cells B10 and C10 (both should be highlighted)

2) Enter the following array formula using CONTROL+SHIFT+ENTER:
=VLOOKUP(A10,A2:E5,{2,5},0)

Hope this helps!
 
Top