select from list and get value from another list

C

crashcrystal

What formula can I use to fill in cell I7 with a value from a list (in column
L) using another list (in column K).

The scenario: I have a list of prices (column L) associated with a list of
descriptions (column k) and want to be able to pick a description in a
drop-down menu in cell I7 and have the associated price pop up in that same
cell. Is this even possible?
 
J

John

Hi
If your drop-down list is in I7, you can't had a formula in that list but if you
put this one:
=I7&" "&VLOOKUP(I7,K2:L27,2,0) in an other cell, you'll get what you're asking.
HTH
John
 

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

Similar Threads

Compare 2 lists and return value 2
Help! Is this possible 2
SUM determined by drop-down list 9
drop down list 1
Using ISNA on more than one column within an If Function 2
Excel Excel: How do I put a formula in a drop down list 11
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Value depends on comination of 2 columns 6

Top