There is a threshhold value that I need to compare projected values to.

When the projected value becomes the threshhold value, I need to
display the date when that happens and if it doesn't happen in the
projected data then n/a.

Dates are in rows across the spreadsheet, with corresponding
projections in rows below. Threshhold and current values are in a
second (summary) spreadsheet in the same workbook.


Thanks for any help you can offer.

DJ


--
DeejGCK
------------------------------------------------------------------------
DeejGCK's Profile: http://www.excelforum.com/member.php...o&userid=32539
View this thread: http://www.excelforum.com/showthread...hreadid=523232