need help with this dropdown multi list.
B1 is the dropdown list that holds 4 lists (ad, el, mr, sz) this are lists
that hold the codes for group names (TB =The Beatles BD= Bob Dylan..so on)
I have Colum A linked to the Above drop don, so that if AD is selected in
B1 then in A5 the dropdown list is AD and if B1 is MR then A5 drop down is
changed to MR. this part works good. Now the proublem I want colum C to
show the Group name depending on what colum A has in it.(I have the List
setup and can get it to work (sort of) I have 2 ways to do this now. The
first works but only if the formula is changed to match the colum A
selection. This takes 4 dofferent formulas
1. =VLOOKUP(A5,week1:Data!E2,5,FALSE)
2. =VLOOKUP(A5,el:Data!F2,5,FALSE)
3. =VLOOKUP(A5,mr:Data!G2,5,FALSE)
4. =VLOOKUP(A5,sz:Data!H2,5,FALSE)
so I changed it to look like this
1. =IF($B$1="ad",(VLOOKUP(A21,week1:Data!E2,5,FALSE)) ,IF($B$1="el",VLOOKUP
(A21,el:Data!F11,5,FALSE)))

2. =IF($B$1="mr",(VLOOKUP(A22,mr:Data!G16,5,FALSE)),I F($B$1="sz",VLOOKUP
(A22,sz:Data!H12,5,FALSE)))
now it takes 2 to do this the best I could do was have 3 lists in 1 of the
above formulas (I can alwas change the lists to be 3 insted of 4 so this
is not the issue) Heres the proublem If A6 is TB then C6 is The Beatles.
but if I change the List in B1 to say EL so I can select EP in A7 so Elvis
Prestly shows up in C7 : then the Text in C6 changes to false What I am
looking for is what can I do to keep the last selection from changing every
time I add new selection in a cell.