Excel - Possible to do a Vlookup with Startswith or Contains?
Posted on 2011-05-10
Wanted to know if there is a way to do a Vlookup formula that can match using a startswith or contains?
Account Name Sheet 1 Account Name Sheet 2
ACS Systems ACS
From sheet 2, I want to pull ACS Systems from sheet 1 using a startswith to match from ACS on sheet 2.
Is this possible? Is so, please post the formula?