I need to monitor the "Thru-Put" assigned to each of our customers - this
table is called "Thru-Put". The Thru-Put is the sum of "Raw" ThruPut and
Adjustments. I am looking for a formula to place in C that gives this result:

BOXID Raw ThruPut Adjusted ThruPut
BOX050 80 87 (80+2(GOOG)+1(MSFT)+4(QQQQ)
BOX060 115
BOX234 1

My main table tracks the assignments - this table is called "Assignments".
It looks like this:

BOX ID SYMBOL
BOX050 ELN
BOX050 GOOG
BOX050 MSFT
BOX050 QQQQ
BOX050 RFMD
BOX050 RIG
BOX050 YHOO

My "adjustment" table looks like this - this table is called "Adjustments":

Symbol Adjustment
GOOG 2
IWM 1.67
MSFT 1
QQQQ 4
RIMM 1
SPY 1


So I think I need a formula for my Thru-Put Table that takes the value in
ColA, looks for a match in the Assignments Table, and for each match found,
check for a match on the Adjustment Table, if a match is found, add the
adjustment value to the Raw Thru-Put value in the Thru-Put Table.

Thank you in advance.