drop down box

[Sam]

How can I do this:
I have drop-down boxes that are referring to a list, say
A1:A5. I want a cell right next to the drop down box
that will return information in B1:B5 for whatever item I
select in the drop-down list. If I select "3" from drop
down, I want next cell to automatically return "yellow."

A B
1 red
2 red
3 yellow
4 blue
5 green

 

[JulieD]

Hi Sam

=VLOOKUP(D1,$A$1:$B$5,2,false)

this means - lookup the value in D1 (ie your "3") in the table defined as
A1:B5, go to the 2nd column and return the value from there.

Hope this helps
Cheers
JulieD