Using text from one cell in a formula to retrieve cell values from a different sheet

Hi,

I'm working on a file that has two sheets, sheet "a" contains a large matrix of numerical data, and sheet "b" has a long list of x and y (column and row) values in separate cells which correspond to a specific value in sheet a.

eg.

in sheet "b", I have R1C1=117 and R1C2=149. I would like R1C3 to display R117C149 from sheet "a".

So far i've been able to use =ADDRESS(RC[-1],RC[-2],,0,) to generate the text "R117C149" in a third cell, but can't seem to find a way to insert this text into a formula to reference the that cell in sheet "a".

Any help is greatly appreciated.

Thanks,
J

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

Why not simply use INDEX?

=INDEX(a!$A$1:$J$12,B3,A3)

Excel 2016 (Windows) 32 bit

	A	B	C	D	E
1	x1	y1	Reference address for sheet a	desired value	INDEX
2
3	1	2	R2C1	26.04651163	26.04651
4	3	1	R1C3	-268.1318681	-268.132
5	3	2			-48.0687
6	8	4			-115.337

Sheet: b

Doesn't matter - we all have to start somewhere. Excel is hugely powerful - have a look through the functions under the bonnet. I have learned most of what I know here!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.