If your data values on sheet 2 are in A1:C25, then those results are exactly
what Mike H's formula gives you.
If you have put your data values in a different place on sheet 2, then
adjust Mike's formula to look at the locations where you have put your data.

It's no good just saying: "I still can't seem to get that to work"
What data do you have where? What result did you get from the formula for
what inputs?
--
David Biddulph

"Rob" wrote in message
...
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