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

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

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?

2. 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

3. 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)`

4. Originally Posted by 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
This is exactly what I needed! countif() is pretty damn useful!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•