VLOOKUP, I think
 

In a relitively small test table I am trying to look up. I am trying to use
VLOOKUP. In Sheet 1, I have a table which contains various properties in
column B and the cost of the job for the property in column E.

On Sheet 2, I have a list of all the properties next to which i want to
return the total cost of all jobs in Sheet 1, I can do this using
=VLOOKUP(A1,Sheet 1!B5:E35,4,TRUE). But this will only return the last time
that the property is mentioned in the table. ie. If '1 Helston Road' is in
'A1' but then appears twice in Sheet 1 eg. B6 and B32 the formula will return
the price in E32. I would either like it to return the Sum of E6 and E32 or
the Value of E6 in one cell and then the Value of E32 in the cell immediately
to it's right.

I hope that I have explained this well enough for someone to understand.

Thank you in advance for any help you can give.

I'm sure that when I find the answer to this it will seem very simple.

Matt Townsend

Hi
use SUMIF. e.g.
=SUMIF('sheet1'!B5:B35,A1,'sheet1'!E5:E35)

"Matt T" wrote:

In a relitively small test table I am trying to look up. I am trying to use
VLOOKUP. In Sheet 1, I have a table which contains various properties in
column B and the cost of the job for the property in column E.

On Sheet 2, I have a list of all the properties next to which i want to
return the total cost of all jobs in Sheet 1, I can do this using
=VLOOKUP(A1,Sheet 1!B5:E35,4,TRUE). But this will only return the last time
that the property is mentioned in the table. ie. If '1 Helston Road' is in
'A1' but then appears twice in Sheet 1 eg. B6 and B32 the formula will return
the price in E32. I would either like it to return the Sum of E6 and E32 or
the Value of E6 in one cell and then the Value of E32 in the cell immediately
to it's right.

I hope that I have explained this well enough for someone to understand.

Thank you in advance for any help you can give.

I'm sure that when I find the answer to this it will seem very simple.

Matt Townsend