S
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
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