Pulling a number with Vlookup within a sentence

[SoFlo24]

I'm trying to pull a number from a sentence using Vlookup. In cell A it has, "Based on Sales Orders 5078857", and cell B I have "34357". Any help would be great.

 

[ShuStar]

Try:
=vlookup ("*"&cell B, table, column number of table, 0)

 

[ShuStar]

Ignore that vlookup.

Once you got the cell with the data, next would be to pull the number only - so question:
-is the number always at the end of the text
-is the number always 7 digits?

If so, use a Right function. If not, explore using MID function.

Example using Right function (based on assumption from above - adapt as needed):
RIGHT((your vlookup), 7)

 

[SoFlo24]

Unfortunately, it did not work. I'm looking back now and I see that I did not really explain it all that well, sorry about that.


On my first page I have
Based on Sales Orders 5078857 in cell A and 34357 in cell B

On my second page I have just the number 5078857 in A and I would like to pull up 34357 in cell B almost on the second page.

The number is always at the end of a text and no it is not always 7 digits.

 

[Fluff]

How about
=INDEX(Sheet1!$B$2:$B$1000,MATCH("* "&A2,Sheet1!$A$2:$A$100,0))