I have a table, listed below, and i need to return the sum of the matching
cells from the lookup. i think its explained pretty well below. The vlookup
formula stops after it finds the first match. i need it to find all matches,
sum them, and return to the cell.

A B C D E
1 PO# AMT

2 1003 75

3 1003 33

4 1006 21

5 1003 19

6 1006 67

Need to return:
Cell A9 -- 1006 - 88
Cell A10 -- 1003 - 127

Currently using the vlookup formula i can only return 75 for PO 1003. this
is because it is the first value listed.

Any clues on how to return all values next to PO 1003 and sum them??

Many thanks.