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

Tom98

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

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

kweaver

Well-known Member
It would greatly help if you used XL2BB and show an example.

Replies
2
Views
301
Replies
0
Views
130
Replies
3
Views
178
Replies
16
Views
283
Replies
3
Views
129

1,141,309
Messages
5,705,675
Members
421,404
Latest member
Mikecollo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back