I'd posted a piece about using indirect references on the Libreoffice forum.
This is where it is:
https://ask.libreoffice.org/t/how-can-i-get-the-current-cell-column-letter/39139/4?u=her_kitty_daddy
The thing was how to get the values another cell points to.
If you used that sort of solution with the column fixed as "A" and use the
value in "C" to refernce the row involved.
See if that leads you to a solution?
--
<< MCT >> Michael C Tiernan. http://www.linkedin.com/in/mtiernan
Non Impediti Ratione Cogatationis
Women and cats will do as they please, and
men and dogs should relax and get used to the idea. -Robert A. Heinlein
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
