How can I use VLOOKUP to find multiple instances of the variable?

[psudoplex]

Please reference the attached file.

Basically what I am attempting to do is use VLOOKUP to fill in the "???". I need to calculate the percentage of completion that is 100% for each person. For example Jason Smith would be 27% complete (3/11), Jessica Pruitt would be 25% complete (1/4). Anything other than 100% is "not complete". How can I use VLOOKUP (or other method) to accomplish this?

[vron692004]

Hi,

I have attached the file with the resolution to your query.
Let me know if this works out for you.

Thanks & Regards,

Varun Mathur

[kvsrinivasamurthy]

Make a slight change. IN E2 use then drag down.

=COUNTIFS($A$1:$A$23,$D2,$B$1:$B$23,100%)/COUNTIF($A$1:$A$23,$D2)

[psudoplex]

Hi,

I have attached the file with the resolution to your query.
Let me know if this works out for you.

Thanks & Regards,

Varun Mathur

This is exactly what I needed! countif() is pretty damn useful!