Previous Topic Next Topic

Return Value in Cell Address

Closed
Pluh - 28 Dec 2016 à 16:46
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 28 Dec 2016 à 16:57
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!
Related:

1 response

Réponse 1 / 1
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
28 Dec 2016 à 16:57
Pluh, Good evening.

Try to use:

=INDIRECT(H3)

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

Similar discussions

Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response