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?
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?