Pete, thanks for trying to help. But I don't know how to look into the
sales value from 2 different sheets but for the same affiliate ID.

I don't know if that's what I am supposed to use the vlookup for.


--
skuba
------------------------------------------------------------------------
skuba's Profile: http://www.excelforum.com/member.php...fo&userid=6696
View this thread: http://www.excelforum.com/showthread...hreadid=503110