Vlookup with not exact matches.
Is there a way to lookup values where the matches are not exact. For example I have in Column A names, & column B I have serial numbers.
See below for illustration
Column A………. ColumnB
John James Smith 12589
George warrington 58968
Is there a vlook up formula that will give the result I want if I just input “John James” or “George war”
Thanks
Is there a way to lookup values where the matches are not exact. For example I have in Column A names, & column B I have serial numbers.
See below for illustration
Column A………. ColumnB
John James Smith 12589
George warrington 58968
Is there a vlook up formula that will give the result I want if I just input “John James” or “George war”
Thanks