Hello,
I'm not sure how to do this with Excel function. My data might look something like this:
1
2.3
5
12.5
17
20.1
30.3
20.7
17.3
12.7
5.9
2.9
1.1
Say I want to find the cell closest to 30. Normally, if my data was only in ascending ordering I'd use Indirect(address(match(30,A:A,1),1), but what I want to find the cell closest to 30 with data that ascends then descends? If I use the same formula, it just returns the last value?
Thanks in advance, Natalie
Bookmarks