Forum Discussion
Solved
vlookup issue
Hi Expertise, I have a problem regarding to vlookup issue. I need to use the staff ID prefix which is the first 3 characters (numeric or alphanumeric) of staff ID to lookup the team. I tried to use ...
How about this:
=XLOOKUP(TRIM(LEFT(A2,3)), TRIM(E2:E4), F2:F4, "Not Found")
How about this:
=XLOOKUP(TRIM(LEFT(A2,3)), TRIM(E2:E4), F2:F4, "Not Found")