I have this on b2
TR-0217/KT-0233
and i have this on m and n
TR-0217 AQUARIUS
My formula on J below not works
=VLOOKUP(B2,M:N,2,FALSE)
I want the vlookup to look 7 character thus then give me result AQUARIUS instead of plugging #N/A
I have this on b2
TR-0217/KT-0233
and i have this on m and n
TR-0217 AQUARIUS
My formula on J below not works
=VLOOKUP(B2,M:N,2,FALSE)
I want the vlookup to look 7 character thus then give me result AQUARIUS instead of plugging #N/A
Try this.
=VLOOKUP(LEFT(B2,7),M:N,2,FALSE)
If posting code please use code tags, see here.
Wow Norie that was fast
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks