Results 1 to 4 of 4

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

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

  2. #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
    Attached Files Attached Files

  3. #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. #4
    Quote Originally Posted by vron692004 View Post
    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
  •