Thread: if function
View Single Post
  #2   Report Post  
Bernard Liengme
 
Posts: n/a
Default

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,