In my example table below I have a workbook that contains an "Index Key" column that shows if I have multiple duplicate site # entries by designating an A for 1, B for the 2nd instance, C for the 3rd and so on. I am doing a VLOOKUP against a vendor supplied workbook daily and my question is how do I track if the vendor add more entries for the same site #? (i.e. if I show 4 entries for site 49027 below and tomorrow's workbook I receive has 6 entries for the same site #. I created the Index Key manually and now I need to automate the process. I appreciate your assistance.


Index Key Site # Scope
A 49027 WAN Circ Only
B 49027 WAN Circ Only
C 49027 WAN + Rtr Mgmt
D 49027 WAN Circ Only
A 49028 WAN Circ Only
B 49028 WAN + Rtr Mgmt
A 53920 WAN + Rtr Mgmt
A 58836 WAN + Rtr Mgmt