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
Lovely