Assistance Needed: VLOOKUP Not Functioning Properly

You may also go with FILTER() function like-

=FILTER(F:F,E:E=K14,"")

It looks like you're having trouble with VLOOKUP. Could you provide more details on the issue? Are you getting an error message, or is it returning incorrect results? Also, check that:

1. The lookup value is in the first column of the table array.
2. The table array range is correct.
3. The column index number is accurate.
4. Exact/approximate match (TRUE or FALSE) is set correctly.

Let me know more details, and I'd be happy to help troubleshoot! 🚀

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