In the attached sheet, I am attempting to lookup a zip code located in column E to see which grouping of zips to which it belongs in column A, then return the Salesperson from column C. My vlookup using wildcards is not working and throwing an N/A error: =VLOOKUP("*" & E2 & "*", $A$2:$C$7, 3, FALSE). Both columns A and E are formatted as plain text.
Thanks in advance for any help!
Last edited by Beggerth; 04-17-2020 at 12:44 PM.
Try something like below...
=LOOKUP(2,1/ISNUMBER(FIND(TEXT(E2,"@"),A2:A7)),C2:C7)
"Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
― Robert A. Heinlein
The problem is length of source in column A and yes Find can help but i recommend to add separators
Please Login or Register to view this content.
That worked, thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks