Thread: if function
View Single Post
  #1   Report Post  
Don
 
Posts: n/a
Default if function

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,