Notifications
Clear all
Topic starter
Hello -
Is there a way to return a result for potentially both an exact match or an approximate match using VLOOKUP or Index/match? I can make it work one way or the other, but not both.
As an example, if I enter 259 in the attached sheet (cell I9) I should get 1 as a result, and if I enter 260 I should get 0 as the result. However, entering 260 returns the result from the previous row, 40.
Thanks for any suggestions with this.
Dave
Posted : 23/06/2018 1:56 pm
Hi Dave
See if this is what you are looking for.
=VLOOKUP(I9-1,E9:F30,2,1)
Sunny
Posted : 24/06/2018 12:28 am
Topic starter
Thank you Sunny, very simple, effective solution. I appreciate the help.
Dave
Posted : 26/06/2018 10:24 am
Hi Dave
You're welcome.
Sunny
Posted : 26/06/2018 9:12 pm
