Excel Forum

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.