Is it possible to embed a COUNTIF statement within VLOOKUP?

[70pjsmith]

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!

[cbatrody]

Hi,

Can you please post a sample excel file here? It's easier to understand the requirement by going through the excel file along with description.

[70pjsmith]

Hi, thanks for your reply. I can't for the life of me figure out how/where to attach a file. Can you give me an idea?

[Glenn Kennedy]

Ha Ha!! Even when you figure it out, it doesn't always work!!!

Click on GO ADVANCED and use the paperclip icon to open the upload window.

The paperclip icon

[JohnTopley]

Click "Go Advanced" then "Paper Clip" icon which take into Upload facility