Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick # 159: VLOOKUP Duplicates 1st Column


Solve Duplicate VLOOKUP function problem with COUNTIF formula that creates a column of unique values for the first column in the lookup table.
COUNTIF function & ampersand & concatenation to create column of unique values in first column of lookup table so that VLOOKUP function can deal with duplicates.
Also see: Excel Magic Trick #148: Dynamic List from Table #3





Got a Question? Ask it Here in the Forum.