VLOOKUP and Multi Lists
?B?TWlndWVsIFphcGljbw==?=
wrote in
:
=IF(LEFT(A15,1)<"E",VLOOKUP(A15,week1:Data!E1,5,FA LSE),IF(LEFT(A15,1)<"
M",VLOOKUP(A15,el:Data!F1,5,FALSE),IF(LEFT(A15,1)< "S",VLOOKUP(A15,mr:Da
ta!G1,5,FALSE),VLOOKUP(A15,sz:Data!H1,5,FALSE))))
this was perfect - your great it worked the way I wanted it to. Many thanks
|