Download Excel Start File: [ Ссылка ]
Download Excel Finished File: [ Ссылка ]
Full Page With All File Links: [ Ссылка ]

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

свернуть