I made a formula that searches an array to return a value, and now I want excel to "show its work" and tell me in which cell it found that value. I've been fighting with
ADDRESS but so far have been only able to return the value's position within the array and not its absolute cell reference.
As a secondary goal, I want to take that cell reference and look one cell down and one cell to the left, then return whatever value it finds there. I don't know if that's a goofy way of doing it but that's my idea so far. Any better methods would be appreciated.
The actual file: https://dl.dropboxusercontent.com/u/78225/test_sheet.xlsx
EDIT: the formula I'm using, which is returning the right value but I want to find that value's cell reference: