Use the row and column number to get the cell value

[BNCOXUK]

Hi, if we don't use offset() function, we can probably use the following approach to fetch the cell value using its row number and column number:

INDIRECT(ADDRESS(A1,A2))

Here, suppose A1 and A2 store the row number and column number respectively.

But the one here only applies to the same sheet. What if i want to get value from a different sheet? For example, two sheets: Sheet 1 and Sheet 2.

If I type the formula in Sheet 2:

=INDIRECT(Sheet1!ADDRESS(A1,A2))

Then this results in an error.

Can you please correct this as a good knowledge?

[BNCOXUK]

I know how to do it now. Just:

=INDIRECT("Sheet1!"&ADDRESS(A1,A2))

[brynbaker]

You need apostrophes around the sheet reference.

=INDIRECT("'Sheet1'!"&ADDRESS(A1,A2))

[brynbaker]

you beat me to it! Well done.