drop down list function help

D

doodiehow

I am trying to perform a task in excell. I have a list of names for products
in col B.
In col. C I have a list of prices. I need to know how when I use drop down
list at the bottom of B col. I can have it pull down corresponding price into
col. C.
 
T

T. Valko

One way...

Product list in the range B2:B10
Price list in the range C2:C10

Product drop down in B25

=SUMIF(B2:B10,B25,C2:C10)
 
G

Gord Dibben

See help on VLOOKUP and Data Validation dropdown list.

You will select the name from Data>Validation>List and in C you will have
the VLOOKUP formula.


Gord Dibben MS Excel MVP
 

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

How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Drop down lists in seperate columns 5
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Font drop-down menu very slow 0
Calculating Average, Count, Min & Max against a range of Values 0
Dynamic Naming of Form Button 3
validation drop down list question 1

Top