Hello everyone;
I have two formulas that are currently "housed" on separate sheets that I would like to combine into one, on the second sheet. Both of the formulas below work separately. What I would like to occur is the COUNTIF to be executed if the VLOOKUP is a match (the scenario is, if there is a match on employee name, count the number of "Yes" in the range specified in the COUNTIF formula). Any suggestions?
The following formula works on the first sheet:
=IF(COUNTIF('Reviewer Database'!$AE8:BS8,'Reviewer Database'!BT$7)>0,"Yes","No")
The following formula works on the second sheet:
=VLOOKUP($B6,'Reviewer Database'!$C8:CH82,70,FALSE)
Combine the two above into one formula, located on the second sheet (my attempt below does not work):
=VLOOKUP($B6,'Reviewer Database'!$C8:CH82,MATCH(IF(COUNTIF('Reviewer Database'!$AE8:BE8,'Reviewer Database'!BT$7)>0,"Yes","No"),'Reviewer Database'!$C8:CH82,FALSE))
Thanks for any guidance!
Bookmarks