Excel

J

Jeremy

I have a worksheet I am stumped on:

I have a row that is sorting data with an IF statement the
if statement returns either "REHAB" or "Review". I need to
know the year that the REHAB value is returned (I have the
year labeled in a different row immediately above the
REHAB/Review row).

I would like the formula to search for REHAB and return
the 1st year that REHAB appears and stop. From there I
will add 20 years to the returned value.

Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Value of the first day of a year in a list 5
If formula producing #VALUE Error 2
Lessor Of or Greater of Nested Function 1
return multiple values when within range (greater than and less than) 11
Allocate an income payment over a date range (tax years) 7
Comparing 2 columns from 2 different Worksheet and Returing Value of a 3rd column 2
Finding location (or start cell) of highest consecutive values 3

Top