Hey Everyone,

I have a two way lookup formula that needs a little tweeking.

=IF(I3<=$Z$1&I3>=$W$1,VLOOKUP(A3,'PREVIOUS MASTER1'!$A$1:$N$1200,MATCH(H3,'PREVIOUS MASTER1'!$H$1:$N$1,0)+7,FALSE),"")

$Z$1 = 6/01/2014

$Y$1 = SERIAL # OF 6/01/2014

$V$1 = 11/1/2013

$W$1 = SERIAL # OF 11/1/2013

$T$1 = 6/1/2013

$S$1 = SERIAL # OF 06/01/2013

$H$1:$N$1 = Sunday, Monday etc.....

The problem is that it pulls the data correctly, put if the date doesn't the criteria it still pulls a date from the array, instead of ignoring it.

This was split from a larger formula that almost worked I thought if could at least get the one portion to work that maybe i can just have 3 formula columns instead, here's the main formula

=IF(I3>=$Y$1,VLOOKUP(A3,MASTER!$A$1:$N$1200,MATCH(H7382,MASTER!$A$1:$N$1,0),FALSE),IF(I3<=$Z$1&I3>=$V$1,VLOOKUP(A3,'PREVIOUS MASTER1'!$A$1:$N$1200,MATCH(H7382,'PREVIOUS MASTER1'!$H$1:$N$1,0)+7,FALSE),IF(I3>=$S$1&I3<=$W$1,VLOOKUP(A3,'PREVIOUS MASTER2'!$A$1:$N$1200,MATCH(H7382,'PREVIOUS MASTER2'!$H$1:$N$1,0)+7,FALSE),"")))

ANY HELPED WOULD BE GREATLY APPRECIATED.