I have a problem that is probably easy to solve, but I am having trouble and only the experts here can help me.

I have a list of values that I am doing a vlookup against. Some of the values repeat, but I only want to see the first one. The reason being that I am summing or counting the returned values. For example:

Values Return
ABL345 22
EBA123 7
ABL345 22 <- Don't want to see this one as it has already been returned
YUI743 13

Any suggestions would be greatly appreciated.