Excel Magic Trick # 159: VLOOKUP Duplicates 1st Column

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
From:
ExcelIsFun
Views:
9080

10
ratings
Time:
03:59
More in
Science & Technology