LinkBack URL
About LinkBacks
Can anyone help with a formula that would go in Cell E to find the value that is closest to Cell A from the results in Cells B:D? Thanks in advance.
A B C D E
33446 33641 33624 33400
Can anyone help with a formula that would go in Cell E to find the value that is closest to Cell A from the results in Cells B:D? Thanks in advance.
A B C D E
33446 33641 33624 33400
Try
=INDEX($B$1:$D$1,MATCH(MIN(ABS($B$1:$D$1-$A$1)),ABS($B$1:$D$1-$A$1),0))
above assumes data in A1:D1, adjust to suit.
Formula must be confirmed with CTRL+SHIFT+ENTER not just ENTER
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
A=33446 B=33641 C=33624 D=33400 E=___?___
Sorry didn't paste as I expected.
See my suggestion above.Originally Posted by r2d2
Brilliant, thanks very much.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks