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!
Enter this formula in C3 of sheet1:
=IF(B3="Yes",IF(VLOOKUP(A3,Sheet2!A:B,2,0)="Yes","Online Tests","Failed at initial shifts"),"NA")
It will display NA for those entries which show a "No" in column B of sheet1.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi Nicola,
You can do this all in one column with the formula below.
=IF(IFERROR(VLOOKUP(A3,Sheet2!A3:B6,2,FALSE),"No")="YES","Online Test","Failed at initial sift")
Thank you, problem solved!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks