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.

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)

--
Biff
Microsoft Excel MVP


"doodiehow" wrote in message
...
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.

See help on VLOOKUP and Data Validation dropdown list.

You will select the name from DataValidationList and in C you will have
the VLOOKUP formula.


Gord Dibben MS Excel MVP

On Mon, 8 Sep 2008 09:19:03 -0700, doodiehow
wrote:

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.