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!!
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!!