bakermetal,
when DonkeyOte is right, he's right! My formula will produce an error if the lookup value can not be found, and would require encasing in an IF() statement to manage that, whereas DonkeyOte's formula will gracefully present you with a zero for values not found in the list.
Check back if you need more help.
cheers
Bookmarks