Auto-populating based on a drop-down list...???

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
 
P

Paul Corrado

Assuming you have that data somewhere in a table with the Products somewhere
to the left of the Spec and Price information you can use VLOOKUP
 
Top