Forum Discussion
XLOOKUP
HI its difficult to understand x look up is the last argument is true , pl explain
1 Reply
The last argument of XLOOKUP is the search mode - it can be 1, -1, 2 or -2.
Did you perhaps mean VLOOKUP?
HI its difficult to understand x look up is the last argument is true , pl explain
The last argument of XLOOKUP is the search mode - it can be 1, -1, 2 or -2.
Did you perhaps mean VLOOKUP?
