This may be a tough one for me to explain but I've posted a screen shot and attached example spreadsheet. Basically, if a cell has the word "RECONCILED" in it, I want to look at the cell above it and find see if the word "CHANGE" is there. If it is, it needs to look at the cell above that and see if the word "CHANGE" is there. It will repeat this process until the last "CHANGE" is located and choose the value in a cell adjacent to it. Another formula would do the same thing except look for the first "CHANGE" instead of the last.
Hope all that makes sense... lol. This is kind of a tricky one.
dateexample.PNG
Bookmarks