Hi,
Reference values.
Hi,
Reference values.
Last edited by aslam5420; 07-10-2022 at 10:05 AM.
This SHOULD work, but isn't doing so and I am struggling to work out why:
=MATCH(J5,F:F,0)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi AliGW,
This worked for simple Numbers.
But for my case it gave an error.
I know it gives an error - I said I was trying to work out why. The numbers match, so I can't at the moment find a workaround.
This ALMOST works, but gets the third one wrong:
=XLOOKUP(J5,F:F,ROW(F:F),"",1)
AliGW on MS365 Beta Channel (Windows 11) 64 bit
J K L M 4 Reference Values Expected Results (Row Numbers) MATCH XLOOKUP 5 0.079166667 17 #N/A 17 6 0.10625 28 28 28 7 0.128472222 36 #N/A 37 8 9 10 11 TRUE=J5=F17 12 TRUE=J6=F28 13 TRUE=J7=F36
Sheet: Sheet1
Hi AliGW,
Yes, Third one is wrong
Yes, I know - I told you that.
What I am TRYING to do is work out WHY, brcause they should both work.
I was trying to work this out as well.
Weirdly if you copy and paste J5 to F17 (or vice versa) it works as expected with MATCH
This WILL work:
=XLOOKUP(ROUND(J5,2),ROUND(F:F,2),ROW(F:F),"",0)
You can change the number of decimal points to suit yourself as long as they are the same for both.
It's one of those floating point error issues, I think.
Hi AliGW,
In #9, formula worked perfectly. Thank you so much for your efforts.
Glad to have helped.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks