Hey there,
Ok heres an idea, try not using a vlookup but a sumif instead.
here it is:
=SUMIF(A1:A6,B25,B1:B6) A1:A6 is your employee ID Range on your data
sheet, B25 is your employee ID you wish to reference, B1:B6 is amount
range on your data sheet. this gives you 350.
hope this helps.
Any more help give me a shout.
Blounty
--
blounty
------------------------------------------------------------------------
blounty's Profile:
http://www.excelforum.com/member.php...o&userid=32632
View this thread:
http://www.excelforum.com/showthread...hreadid=524384