Tell us more about how your data is arranged.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Don" wrote in message
...
I need help with a formula.
I have a spread sheet that tracks equipment, replacement cost, lifespan,
replacement date and a second replacement date (xx months after it was
originally replcated)
I am have a 36 columns with each month for 3 years. I would like to look
up
both replacement date cells to see if they fall in the column with the
current month/year. If it does then I would like to pull the column with
the
replacement cost.
Thanks,