I ahev a workbook with 20 sheets in it, all template forms for completed
jobs. On the first sheet I have the date in cell a2. b4 back dated 1
year from a2. I need to lookup cells c2:d2{(merged)this is a completion
date}. in all the 19 remaining sheets and show the date if it is within
the month back dated 1 year.

sheet 1 a2= "September 30, 2005" with formula (=today())
sheet 1 b4= "September-04" with formula (=a2-365)

sheet 2 c2:d2="September 30, 2004"
or the same as above only in sheet 19.

the fromula i have now is =VLOOKUP(B4,'Job 1'!C2:D2,TRUE) and it works
for one sheet, i need it to lookup all 19.


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=472220