Thanks for the explanation of the codes, with that, maybe this formula will
do what you need:
=IF(LEFT(A15,1)<"E",VLOOKUP(A15,week1:Data!E1,5,FA LSE),IF(LEFT(A15,1)<"M",VLOOKUP(A15,el:Data!F1,5,F ALSE),IF(LEFT(A15,1)<"S",VLOOKUP(A15,mr:Data!G1,5, FALSE),VLOOKUP(A15,sz:Data!H1,5,FALSE))))
It checks the first letter of A15 to pick the correct list to search, and it
covers the four possibilities. Is this it?

Miguel.

"dpatte601" wrote:

?B?TWlndWVsIFphcGljbw==?=
wrote in
:

=IF(ISNA(VLOOKUP(A16,week1:Data!E2,5,FALSE)),VLOOK UP(A16,el:Data!F16,5,
FALSE),VLOOKUP(A16,week1:Data!E2,5,FALSE))

this may work (with some work) but still if I change A15 so it now lists MR
then the #N/A comes up I need it to change as I select different lists in
B1.
You see this is the mainpage of the data base that has other pages (not
listed) that hold the CD names and band info. such as Name ,CD number, Type
of Music. there are 4 pages 1 is AD (from A to D) then there is E to L , M
to R , and S to Z.
What I need is a formula that can always hold the last B1 selection in the
cells even if B1 changes.
this formula
=IF(ISNA(VLOOKUP(A16,week1:Data!E2,5,FALSE)),VLOOK UP(A16,el:Data!
F16,5,FALSE),VLOOKUP(A16,week1:Data!E2,5,FALSE))
needs to incorporate MR and SZ as well as AD and EL
Hope this help you understand what Im looking for.
thanks