I am having difficulty identifying a formula that will lookup a number in a worksheet and then if the number is present I want it to see if that number has a corresponding "Yes" or "No" in a different column. If it has a "Yes" I want it to retun the word "Online Test" and if it is "No" I want it to return "Failed at initial sift". Can anyone help please? I have attached an example.

Test.xlsx

Thank you in advance!