Today’s Excel question from Willie at the UCF Accounting Conference:
I am using a vlookup to get some information from a vendor info database that comes from the credit card website.
 
My issue is that the vendor name sometimes comes with additional info at the end like …. “Contoso – cadet.biz” and in the table where I do the lookup the name is just “Contoso”.
 
I was wondering if you think I can use the “TEXTBEFORE” function with the Vlookup formula to make the formula to look in the table only for the first word of the info coming from the credit card “Contoso – cadet.biz”.

Table of Contents
(0:00) UCF Accounting Show
(0:39) Table with Vendor dash URL
(1:15) Use TEXTBEFORE with VLOOKUP
(1:50) Use TEXTBEFORE, XLOOKUP, for lookup table
(2:50) TEXTBEFORE preventing #N/A
(5:09) Prevent #N/A from TEXTBEFORE in lookup table
(6:55) Check out my Excel video courses on Retrieve