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,
|