View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.newusers
dpatte601
 
Posts: n/a
Default 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