address gnumeric cell with calculated address

jon Elson · 11-09-2022, 02:05 PM

I need to compute the address of a cell in a formula. So a cell has a number in it. I want to compute address=(number-1)*6+4) and then make that into a cell address like B(address).
I can't figure out if there is a syntax to express that in gnumeric.
Any ideas?
Thanks,
Jon

boughtonp · 11-09-2022, 02:19 PM

Try searching for "address" in the Gnumeric Manual...

jon Elson · 11-09-2022, 04:18 PM

Well, that brings up email addresses, there doesn't seem to be a search specific to gnumeric, it searches all of Gnome.
Is there a better place to ask Gnumeric questions?
Thanks,
Jon

boughtonp · 11-09-2022, 04:29 PM

That's Gnome stupid website design.

On the page I linked, use Ctrl-F to get the browser's in-page search, (or use the contents menu to go to section "A.11. Lookup").

jon Elson · 11-09-2022, 06:58 PM

Well, address seems to convert a cell address into text. What i WANT is to get the VALUE of a cell by using numbers from some cell as the address.
Thanks,
Jon

fatmac · 11-10-2022, 04:15 AM

These may help....

http://www.gnumeric.org/

https://help.gnome.org/users/gnumeri.../gnumeric.html

fatmac · 11-10-2022, 04:24 AM

Quote:

address=(number-1)*6+4)

If you mean what I think you mean..

Go to the cell, click the = sign, at the top of sheet, go to the cell holding the number, click it, it will appear at the top, insert -1, then *6, then +4, then hit the 'tick'.

boughtonp · 11-10-2022, 07:58 AM

Quote:

Originally Posted by jon Elson

What i WANT is to get the VALUE of a cell by using numbers from some cell as the address.

To get the contents of a dynamic cell address, use the INDIRECT function.

To get the the contents of a cell from a particular range by using column/row numbers, there's the INDEX function.

To do something similar but different, it'll be one of the other functions in the Lookup category.

jon Elson · 11-10-2022, 09:35 AM

Thanks Boughtonp, indirect does seem to be what I'm looking for! I will have to learn the proper syntax for it, but it should work.
Thanks,
Jon

jon Elson · 11-10-2022, 12:38 PM

Thanks again, boughtonp, combining indirect and concatenate allowed me to assemble the cell references with the arithmetic to select the cells required! I now have the data being extracted from the disjoint lines of entered data.

It looks like this: =indirect(concatenate("B",(A910-1)*6+4)
Jon