Good afternoon all,
I have been using this formula:
=INDEX($J$2:$J$52609,MATCH(MIN(ABS($J$2:$J$52609-$Q$1)),ABS($J$2:$J$52609-$Q$1),0))
..to find the closest number in a large range ($J$2:$J$52609) to the number in Q1. Is there any way I can get the cell reference of the resultant number instead?
Thanks for your help!
I have been using this formula:
=INDEX($J$2:$J$52609,MATCH(MIN(ABS($J$2:$J$52609-$Q$1)),ABS($J$2:$J$52609-$Q$1),0))
..to find the closest number in a large range ($J$2:$J$52609) to the number in Q1. Is there any way I can get the cell reference of the resultant number instead?
Thanks for your help!