Forum Discussion
Ronstp
Mar 14, 2020Copper Contributor
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.
- Mar 14, 2020
You missed if_not_found parameter skipping. On the top is your formula, below is corrected one.
SergeiBaklan
Mar 14, 2020Diamond Contributor
Ronstp
Mar 14, 2020Copper Contributor