=INDEX(A1:D7,G1,F1)

where G1 is y, F1 is x

--
Kind regards,

Niek Otten



wrote in message
oups.com...
I have 2 values(x-axis,y-axis) in 2 fields. by those values I want to
find a field in a table.
i.e. if the top corner of the table is A1, and the values of the x,y
are 3,4.
then I want to take the value in the table at field C4.
thank you