Forum Discussion
Assistance Needed: VLOOKUP Not Functioning Properly
MY VLOOKUP IS NOT FUNCTION PROPERLY
That could be
XMATCH and XLOOKUP do not lookup on multicolumn range, you shall use one column. If to change on
=XLOOKUP(K15,E4:E36,F4:F36,"NA",0,-1)it works
V LOOKUP VALUE
ACTUAL VALUE
could you please guide me solve this issue
That could be
See the attached workbook. Sheet1 is the original; Sheet2 uses (exclusively) XLOOKUP formulas.
Lovely
