Comparing data to give an answer?

Hi guys, dont use excel a lot but have been given a task in work and cant get the right equations for an answer!

There will be sheets with continually updating data although I am only concerned with column U & V on sheet 1. In only some of the cells it will contain text and a number, the number is what I am after as it is an ID.
On sheet 2 I have more data that relates to the ID number, the ID from column U or V will hopefully be found in column A on sheet 2.
I want to return on sheet 1 column Q information relating to the ID. This information will be in the cell adjacent (sheet 2, Column B) to the ID number, called status.

If anyone could help that would be great!

Attached an example of sheet with some ID's not on my data and some on my data.Book_1.xlsx

Thanks for the reply!

Some of the time it will be IFR 123456 etc with the space but often in column U it will be IFR#541566 with the hashtag for a space.

The formula looks like it could be modified to work but currently just showing #VALUE!