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

psudoplex

New member
Joined
Sep 1, 2014
Messages
2
Reaction score
0
Points
0
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?
 

Attachments

  • test.xlsx
    9.5 KB · Views: 13
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
 

Attachments

  • test.xlsx
    9.9 KB · Views: 17
Make a slight change. IN E2 use then drag down.
Code:
=COUNTIFS($A$1:$A$23,$D2,$B$1:$B$23,100%)/COUNTIF($A$1:$A$23,$D2)
 
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!
 
Back
Top