Cell 1 Contains "", Cell 2 Contains "", return value from matrix in Cell 3 (matrix displayed on another sheet)

[Tom98]

Hi,

I have a table displayed on sheet 2 that contains a lot of data running along x (horizontal) and y (vertical) in a matrix form. On sheet one, I would like cell A3 to return the correct value from this table when the x value is inputted in Sheet 1 Cell A1 and the y Value is inputted in Sheet 1 Cell A2. Is there a formula that I can use in Sheet 1 Cell A3 to do this?

Any help with this would be great.

Cheers!!

 

[kweaver]

It would greatly help if you used XL2BB and show an example.