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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

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

Auto-Populate based on Drop-down lists???? 3
Filtered drop down list 2
Linking Excel drop down lists 2
drop down list based on other drop down list pick 1
Selection of drop down list directs auto population of other cell 1
Drop Down List 3
Drop down list 1
Populate List Based on Cell Value - XL2003 1

Back
Top