Hello,
I am trying to find the 5 projects with the largest amount of hours per person (engineer). After I have found the top 5 projects by hours, I want to pull the project name but the problem that I'm running into is when there are more than one project with the same Project Hours. Since I am using vlookup, only the first value will return for each of the same hours. For instance, Order 1 & 2 have Project Hours of 140 and both return a Project Name of No Assigned Project Number. The second value should read Project Number 2 but I'm not sure how to do this with vlookup.
I have attached multiple images showing the equations used in the cells.
Thank you in advance for your help in solving my situation.
Best regards,
Brandon
Bookmarks