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

Drop down list control value in vba 2
Excel does not accept text format! 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
Compare 2 lists and return value 1
Help! Is this possible 2
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Autonumber field in Excel that behaves the same as Access 0
Merging from an Excel file with graphics 1

Top