C
cbrd
I have two worksheets, "WS1" and "WS2".
On WS1 there are two columns with the headings "ID" and "NAME" (The
values for these start on row 3 and end in row 50).
On WS2 I have a cell, G10.
On WS2 i wish to add a drop down list, and in the list, will be all the
values from WS1, Column B3 thru B50('NAMES' column).
When i select a name in the list, I wish for the drop down list to
display in cell G10, the ID from column A3 thru A50 on the same row as
the choice in the drop down list.
I tried this in excel, but the only thing I could get the drop down
list to display in cell G10 was the row number of the name I selected.
I also tried making G11 display the results of the drop down list and
putting this formula in G10, and I just get "N/A":
=INDEX(WS1!A3:A50,MATCH(G11,WS1!B3:B50,0))
Any ideas?
On WS1 there are two columns with the headings "ID" and "NAME" (The
values for these start on row 3 and end in row 50).
On WS2 I have a cell, G10.
On WS2 i wish to add a drop down list, and in the list, will be all the
values from WS1, Column B3 thru B50('NAMES' column).
When i select a name in the list, I wish for the drop down list to
display in cell G10, the ID from column A3 thru A50 on the same row as
the choice in the drop down list.
I tried this in excel, but the only thing I could get the drop down
list to display in cell G10 was the row number of the name I selected.
I also tried making G11 display the results of the drop down list and
putting this formula in G10, and I just get "N/A":
=INDEX(WS1!A3:A50,MATCH(G11,WS1!B3:B50,0))
Any ideas?