You should use VLOOKUP based on the unique entries in column A of he data