drop down list help
Assume the user selects the item in cell A1. In cell B1 enter this
formula:
=VLOOKUP(A1,L$1:M$20,2,0)
this will bring the ID from the table of names and ID (assumed to
occupy L1 to M20) - adjust cell references as appropriate.
Hope this helps.
Pete
|