Drop-down list with Lookup function?

J

jmc784

Can someone please tell me if this is possible?

What I want to do is have a drop-down list, but when you choose a value from
the list, it inputs the value from another list.

for example, if I have the two lists from columns B and C, can I have the
drop-down list have the values in column B, but when you choose the value, it
inputs the value from column C?

If I choose 3 from the drop-down list, I want it to show C in the cell.

A B C
1 1 A
2 2 B
3 3 C


Thanks!
 
J

Jim Thomlinson

The short answer is no. Even if you could I would recommend against it as it
would be rather disconcerting if you choose one thing and another thing shows
up. Let the drop down show what was choosen and put the look up value in
another cell adjacent to the drop down would be my recommendation.
 
J

jmc784

Thanks for the input Jim, I know it would be a little weird. It would be
used for generating a product number based on specifications (simple example:
height 12" = A, color red = 5, could generate product number A5)

But I will probably just use separate cells, then copy and paste the values.

Thanks,

-Jamie
 

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

Top