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 `MATCH`

and `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: `{=MIN(IF($D$1:$DG$1="food",IF(D2:DG2<>"",D2:DG2)))}`

`CELL`

with the array-entered formula`{=MIN(IF($D$1:$DG$1="food",IF(D2:DG2<>"",D2:DG2)))}`

, but it throws an error and won't even let me enter it. Did you take a look at the actual file? – user3161965 Jun 13 '14 at 18:52