Let's say: A2 is your dop down list, and your data in B1:C100

=VLOOKUP(A2,B1:C100,2,0)

Adjust to suit


"Honey" wrote:

Hello!!!

Here is my problem...

I have a drop down list and I want each item on it to display a
differen value in another cell

So if my list is:



C2 Value
Tom 10
Mary 8
sarah 4
Michael 2

So If I selected Tom from the drop down list it would display 10 in C3
or if I selected mary from the drop down list then it would show 8 in
C3.

Any ideas if or how I can do this?

Thanks so much for your help....I'm always amazed by what people can do
on Excel!!!

Honey