Hi,
thanks for looking?
When I download some nominal data from the finance system into excel the supplier number (which is a mixture of letters and numbers) appears either at the start, middle or the end of a text string including other information. Therefore if I am wanting to do a vlookup against this information to get the supplier name against the supplier master table (supplier number in one row and supplier name in the other).
I have a master list of the supplier numbers in one column, supplier name in another column, that the formula can lookup to and hopefully it can return the supplier name as the result.
I am not sure whether the formula I am looking for is like a contain formula, if it contains the supplier number return the supplier name from the list.
Hope this makes sense, any ideas?
Bookmarks