Without knowing more about your data structure, you could use the SUMPRODUCT..

Say you have values of somex, and somey, and you need somevalue, and x and y
are in columns a & b, and value is in c...

=SUMPRODUCT(--($A$1:$A11=somex),--($B$1:$B$11=somey),($C$1:$C$11))

Hope this helps. If it doesn't, please give more details as to your data
structure, if your x and y column lookup is also variable, etc.
--
John C


"Matt G" wrote:

Hi there

I am trying to return a number to a table of information that depends on the
values of two variables x and y.
The variables may take a number of different values (the table I need to
search within for the value I need to return is is 11 rows by 19 columns).
So for a specific x and y I get a certain number back.
I have tried using OFFSET and LOOKUP functions but cant get anywhere.
Please help!
Regards Matt