select from list and get value from another list

  • Thread starter Thread starter crashcrystal
  • Start date Start date
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?
 
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
 
Back
Top