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