Forum Discussion
Solved
Xlookup
When using Xlookup it is not searching last to first in my table if the search date occurs more than once. It is returning the results of the 1st record, not the last.
You missed if_not_found parameter skipping. On the top is your formula, below is corrected one.
You missed if_not_found parameter skipping. On the top is your formula, below is corrected one.
Thank you very much. This solved the problem and works perfectly. I thought "Not Found" was optional.
Thanks again, now I can sleep.
Ronstp , you are welcome
Yes, Not found is optional, but each optional parameter position you need to separate by comma, if only that's not the latest one.