Return Value in Cell Address
Closed
Pluh
-
Dec 28, 2016 at 04:46 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Dec 28, 2016 at 04:57 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Dec 28, 2016 at 04:57 PM
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!
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:
- Use the ifs function to return 5 if cell a5 contains the value 3
- Gta 5 download apk pc - Download - Action and adventure
- Hitman 3 cheats - Guide
- Psiphon 3 download - Download - VPN
- Forza horizon 5 download free - Download - Racing
- Bluestacks 5 - Download - Android emulators
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Dec 28, 2016 at 04:57 PM
Dec 28, 2016 at 04:57 PM
Pluh, Good evening.
Try to use:
=INDIRECT(H3)
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use:
=INDIRECT(H3)
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão