Multiple selection on a combo box

C

Cesar

Hello,

I have a table with 5 columns, column A has the Product Name, columns B to E
have the cost of chemicals used to produc that Product (ChemA, ChemB, ChemC,
ChemD). Using Combo box,looking at the column A for the ListFillRange, I
select a product from the list and put it on the cell F1(LinkedCell). What do
I need to do to copy all the cells (Chems) that belong to that particular
chosen product?, in other
words, I want to copy all the Chemicals used for that product from cell F1 to
F5?
 
G

Gord Dibben

In F2 enter =VLOOKUP($F$1,$A$1:$E$5,ROW(F2),FALSE)

Copy down to F5


Gord Dibben MS Excel MVP
 
D

Dylan @ UAFC

yes you need to use vlookup.
The combo box does not have anything do with
the equation its just a organization of datat
 

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

Copy/Select a Row 4
Counting based on multiple criteria 8
combo box 1
Return Value from a Range (depends on input to determind month) 2
Linking to combo box selection 2
Creating combo box with different number of variables 1
Combo box list selection based on earlier selection by user 2
Lookup on a combo box 1

Top