View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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.