Returning the value from another matrix sheet

Hello All,
I have an "A.xls" file which has two sheets "Main"and "Data".
In the "Data" sheet i have data with row and matrix form for e.g.
in below data A1..C1 are column and 1..6 are rows.
A1 B1 C1
1 35 11 12
2 55 88 24
3 43 67 56
5 78 78 66
6 87 90 56
And in "Main" sheet there are two cells, say A and B for input and C for output.
I want to return the value to the C cell if A( row value of "Data'')and B(Column value of "data") values are entered.
for e,g.
If i put "2 "in the cell A and "B1" in B cell is entered; i should get "88" in cell C.
Pls help me to how to write a formula for it.

Thanks in advance!
Sachin

Hello and welcome to the forum,

I believe what you are looking for is Index and Match. Please have a look at the attachment. The formula is:

Please Login or Register  to view this content.

but since your data structure may change I thought it might be helpful to provide a working example.

Good luck.

abousetta

Originally Posted by abousetta

Hello and welcome to the forum,

I believe what you are looking for is Index and Match. Please have a look at the attachment. The formula is:

Please Login or Register  to view this content.

but since your data structure may change I thought it might be helpful to provide a working example.

Good luck.

abousetta

Thank you.
Its working fine.

Hi,

Glad we could be of assistance. If you are satisfied with the results, please mark the thread as [SOLVED] (next to the title on the first post). Also positive recognition (scales) are always welcomed .

If want to mark the post as solved then:

1) Click the Edit button on your first post in the thread
2) Click Go Advanced
3) select [SOLVED] from the Prefix dropdown
4) click Save Changes

Good luck.

abousetta