Hi
I am looking for a formula to look for a partial number within a column on a different sheet.
The description for example: VEHICLE H1007 STUCK WITH OUT DIESEL, but the h1007 is incorrect as the correct number is JTH1007. But sometimes the vehicle in description does not have a letter in front of it ie 1007. Which formula will be more effective to look for 1007 and return JTH1007.
Just to clarify I have quite a few vehicle numbers that are incorrect in the description line.
I have tried a lookup formula but it only works if the vehicle number is correct. Is there another formula I can use.
Regards
Louis
Bookmarks