Trying to lookup a number in a column

[Louis1983]

Good day,

I am looking for a formula to look for a partial number within a column on a different sheet.

Some of the numbers does contain letters for example H1007 or S0436, but they typed it in as 1007 and 436. The only other problem is the numbers are within a description/sentence.

Please can anyone assist.

Thanks
Louis

 

[snjpverma]

you can simply use ISNUMBER function to know if there are any letters in a cell.

for e.g. =isnumber(A1)

if the output is TRUE it means no letters are there in the cell and vice versa.

 

[SteveO59L]

try posting a sample of your data, and what you would like to do with it

 

[Louis1983]

Hi

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 infront of it ie 1007. Which formula will be more effective to look for 1007 and return JTH1007.

Regards
Louis

 

[Louis1983]

Just to add on the correct vehicle numbers are on a different sheet.

 

[SteveO59L]

ok,

in a1 "VEHICLE H1007 STUCK WITH OUT DIESEL"

in f1:g1 1007 & JTH1007

in c1 =VLOOKUP(MID(A1,FIND("1007",A1),4),F:G,2,FALSE)

 

[Louis1983]

Thank You so much this will work for me.

Regards
Louis