VLookup + Find

Hello All, I have a vlookup that works if I am looking up a vendor name from a cell and searching another file to return the vendor owners name, but it does not work if the vendor name as anything else in the cell ie. (formerly ....), i tried to use the left function but then it does not work at all



Lookup vendor file

Vendor Active / Inactive Notes "Primary Renewal Month" Owner
Accuity (formerly
Safe Banking Systems) Inactive 06 - June Mary

Please Login or Register  to view this content.

Thank you, attached sample vendor file which has the vendor and in column 5 it has the vendor owner, on another sheet I have a cell A4 which I type in the vendor name and it B4 the vlookup to return the vendor Owner name.

What works: if I use the below vlookup for vendor ActivePDF as per sample it will find it

What does not work: if I lookup Accuity it will not find it - returns #n/a, so I tried the 2nd vlookup with left function it still does not find it, I get a #VALUE! error

=VLOOKUP(A4,'[DSAM Vendor assignments.xlsx]Vendor Assignments'!$A:$E,5,FALSE)

=VLOOKUP(LEFT(A4,FIND(" ",A4)-1),'[DSAM Vendor assignments.xlsx]Vendor Assignments'!$A:$E,5,FALSE)

Originally Posted by Pepe Le Mokko

Perhaps =VLOOKUP("*"&A4"*",'[DSAM Vendor assignments.xlsx]Vendor Assignments'!$A:$E,5,FALSE)

Thank you Pepe, that work well after I added an & after a4, much appreciated