Hi all,
I've been playing for a while now and can't figure out if/how to get what I need. I want to find the highest possible number in column A, but from matching to othert criteria.
I want to input a defined number in cell AA3 which references B3:N3, and then input a number in cell AA5. This number will refer to B4:N21, I need it to be equal to or greater than (but be the closest to it) the number in cell AA5.
I then want to return the highest value in column A that meets these criteria.
eg.
If I put 31.2 in AA3, and 18 in AA5, I would want it to return the highest possible number in Column A which is 7 in this instance.
If you need any more clarity please ask, and thanks for any help.
Joe