Hi all.
I have a problem that I'm finding difficult to find an answer for.

the problem I have is that I want cell (Sheet 3; C4) to contain a sum of values from (sheet 1; column E),
and here is the catch,
IF (Sheet 3; C5) has a value that can be matched to a corresponding row cell in (sheet1; column B).

So..... If I put the value 302 into cell (sheet 3; C5) I want the spreadsheet to go and find 302 in (sheet 1; column B) and then add the value it finds in
(sheet 1;column E) on the same row to cell (sheet 3; C4)
BTW. cell (sheet 3 ;C5) will look something like (302, 304, 750).

I hope this makes sense.

The problem is how to describe the problem I have.....