linking items from drop down list in excel
Look at VLOOKUP (I assumed dropdown is via Data Validation)
=VLOOKUP(list_value,A:B,2,0)
where columns A & B contain the (dropdown) list values and their
corresponding value
If list_value (dropdown) is in C1 then:
=VLOOKUP(C1,A:B,2,0)
OR
If the drop down is a combo box (using FORMS) and the link cell is say F1,
with corresponding list in G1:G10 then the formula below will get the
required value, assuming your dropdown list starts in row 1
=INDEX(G1:G10,F1)
HTH
"jog" wrote:
Hi there,
I have a list of items for which i have created a drop down, and i also
have a correspondent list for this list, now how can I get an item
automatically in a different cell from the corespondent list when I
choose an item from the drop down?
thanks.
|