Like I said, it can be done with formulas but it's complicated.

How many rows of data are there? If there are 1000's of rows, using formulas
isn't very efficient.

Biff

"KC2006" wrote in
message ...

That works for me to see it on the current sheet. What if I have
another sheet I want the data returned to??? Sort of like doing a
VLOOKUP, but returning the sum of the lookups.


--
KC2006
------------------------------------------------------------------------
KC2006's Profile:
http://www.excelforum.com/member.php...o&userid=35391
View this thread: http://www.excelforum.com/showthread...hreadid=551661