Vlookup Problems #6: Your Lookup Table Contains Duplicates - Vlookup Multiple Values

★ Like this tip? Find more at http://bit.ly/Computergaga ★ Does your lookup table contain duplicates? Are you trying to Vlookup multiple values? The Vlookup function returns information from the first record it finds. It cannot be used to return all occurrences of a value. If this is a problem, then you have two options. You may wish to remove the duplicates from the lookup table, or you may need to use a different Excel feature to return multiple values. In this video we start by looking at the Remove Duplicates feature to delete the duplicate values from the lookup table, or table array. This feature can be tailored to effectively locate duplicates based on criteria. We then explore using a PivotTable to lookup multiple values. This video serves as just a glimpse into what a PivotTable can do, and focuses on achieving our objective. Join the Audience: ★ Twitter: http://www.twitter.com/computergaga1 ★ Facebook: https://www.instagram.com/computergaga1/ ★ Blog: http://bit.ly/Computergaga This is the sixth and final video in the common Vlookup problems series. In this series we explore the most common reasons why your Vlookup functions are not working. Be sure to check out all the videos in the series for a complete understanding of the anatomy of Vlookup and the potential problems you can encounter.