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

comotoman,

VLOOKUP won't look across sheets. Most of Excel functions don't work across
sheets. You probably need to get all these jobs into one sheet. Take a
look at "Data across multiple sheets" at
http://www.smokeylake.com/excel/excel_truths.htm. You may be inclined to
reject this proposal out of hand, but you're earnestly encouraged to
consider it carefully.
--
Earl Kiosterud
www.smokeylake.com

"comotoman" wrote
in message ...

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