Return Value in Cell Address [Closed]

Report
-
Posts
1870
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 22, 2021
-
Hello,

I'm having an issue returning the value cell A32. I have "A32" stored in cell H3 (it was a long drawn out process to isolate the "A32" that is why "A32" is in cell H3). I've tried to use the function =CELL("contents",H3) to return the contents of what is in cell A32. However, the function is returning "A32" i.e. the contents of H3. Is there anyway to return the contents of cell A32 given that "A32" is in cell H3? Appreciate any tips!

Cheers!

1 reply

Posts
1870
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 22, 2021
139
Pluh, Good evening.

Try to use:

=INDIRECT(H3)

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!