Forum Discussion
Solved
Lookup or calculate nearest bigger value of table items where items are not unique.
Dear All Excel MASTERS, HLEP! Let's say I have an excel file which have 2 sheets : "Inbox" and "Sent" in those sheets, there are 2 columns : "Name" and "SCORE" what I am trying to do, is to alwa...
Hi Behrooz,
Please try this formula:
=IF(ISNUMBER(MATCH(A2,Sent!$A$2:$A$9,0)),
SUM(IF(MIN(ABS(B2-IF(A2=Sent!$A$2:$A$9,Sent!$B$2:$B$9)))=ABS(B2-IF(A2=Sent!$A$2:$A$9,Sent!$B$2:$B$9)),Sent!$B$2:$B$9)),0)And find it in the attached file.
I hope this helps you
Haytham
Hi Behrooz,
Please try this formula:
=IF(ISNUMBER(MATCH(A2,Sent!$A$2:$A$9,0)),
SUM(IF(MIN(ABS(B2-IF(A2=Sent!$A$2:$A$9,Sent!$B$2:$B$9)))=ABS(B2-IF(A2=Sent!$A$2:$A$9,Sent!$B$2:$B$9)),Sent!$B$2:$B$9)),0)
And find it in the attached file.
I hope this helps you
Haytham
Thank you for your help..
Actually Your Post is the correct answer for the question, so I mark your post as the "Best Answer".
but, to make it easier for you guys to help me, I simplified the question, and now this caused an issue.
so I'm going to add a new thread for the real issue, and I think you can help..
then kindly PLEASE take a look at my new post with the link bellow:
Advanced: Formula to calculate elapsed time from 2 given time, based on a string which is not unique
Regards.