I have a list of players scores in a sheet and I pull the results into another sheet where the list is sorted by wins and losses etc. Some players play for more than one team and my formula (=VLOOKUP(AU4,'2012'!A5:AU296,41,FALSE)) only grabs the first found score and does not pick up the second or third score. Can I add the duplicated names scores to the first found name?.
Vlookup with duplicates
- Thread starter Gazzal
- Start date
SirJB7
Excel Rōnin
Hi, Gazzal!
Tried searching within chandoo.org? If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords "vlookup retrieve multiple values" and press Search button. You'd retrieve many links from this website, maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.
Regards!
Tried searching within chandoo.org? If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords "vlookup retrieve multiple values" and press Search button. You'd retrieve many links from this website, maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.
Regards!