Forum Discussion

Copper Contributor

Mar 14, 2020

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.

excel

Formulas and Functions

SergeiBaklan
Mar 14, 2020
Ronstp

You missed if_not_found parameter skipping. On the top is your formula, below is corrected one.

6 Replies

SergeiBaklan
Diamond Contributor
Mar 14, 2020
Ronstp

Could you please give a sample like this?
- Ronstp
  Copper Contributor
  Mar 14, 2020
  SergeiBaklan
  Sorry forgot the row numbers
  - SergeiBaklan
    Diamond Contributor
    Mar 14, 2020
    Ronstp
    
    You missed if_not_found parameter skipping. On the top is your formula, below is corrected one.
- Ronstp
  Copper Contributor
  Mar 14, 2020
  SergeiBaklan
  I hope this helps explain the problem