Rob, If I understand, the other sheet (sheet2) has column A, B, C and the
first Sheet (sheet1) has column A and B and you want C to be updated from
sheet2 by the combiniation in A&B that match. Then I would insert a column
in sheet 2 that would concatinate A and B so it would look like

A B C D
=B1&C1 5 5 25

Then sort by A

Then on shee1 , do a Vlookup in C

=VLookup(A1&B1,Sheet2!$A$1:$D$200,4,FALSE)

hope this helps

"Rob" wrote:

Thanks but I still can't seem to get that to work the results that need to
go into C3 are sitting on another worksheet so if I put

5 in A1 and 3 in B1 how do I get a return of 18 in C1

or

3 in A1 and 3 in B1 the return in C1 needs to be 11 etc etc

Cheers again guys for any help

"Mike H" wrote:

Because the conbimnations are unique you can use sumproduct

=SUMPRODUCT((Sheet2!A1:A25=A1)*(Sheet2!B1:B25=B1)* (Sheet2!C1:C25))

Mike

"Rob" wrote:


Hi guys

Thanks for your responses hopefully this mau make things a little clearer

In one worksheet I am going to be putting in numbers (1-5) in say cell A1,
and then numbers (1-5) in B1, the outcome of these needs to give me a total
in C1 which is sitting on another worksheet, so for example
A1 B1 The figure that needs to go in to C1
5 5 25
5 4 20
5 3 18
5 2 17
5 1 16
4 5 20
4 4 19
4 3 12
4 2 10
4 1 9
3 5 15
3 4 12
3 3 11
3 2 8
3 1 4
2 5 10
2 4 8
2 3 7
2 2 6
2 1 2
1 5 5
1 4 4
1 3 3
1 2 2
1 1 1

The figures themselves may well keep changing but will always been one of
the above combinations but it needs to return the value in C1

Thanks guys


"Rob" wrote:

Hi

I am trying to work out a formula where say for example

A1 3
B1 2

In a different sheet I have a table that says for this combination it must
return a value of 8 in C1 any ideas anyone...There is a range of numbers I am
trying to return for different combinations based on a 5x5 matrix but its not
a simple A1xB1 to give me the solution.

any help would be of use