Hi, I have sales values typed in cells A2 thru A20. If cell A4 happens to contain the highest sales amt, I want "B4" to display as the result of a formula (which is the cell located directly to the right).
I DON'T want the actual value sitting in cell B4 to display, but rather the actual cell address of B4.
I'm experimenting with some variations of IF, MAX, CELL, ADDRESS, INDEX, MATCH functions but am striking out.
Please help! Thank you.
Bookmarks