On 14/12/2011 16:04, Gérard FARGEOT wrote:
=INDIRECT("Data."&Data.H5&Data.M9)
with Letters column identifier in Data.H5 and number row identifier in Data.M9
If column identifier is a number, you can use INDIRECT& ADDRESS
=INDIRECT(ADDRESS(Data.M9;Data.H5;4;;"Data"))
Thanks Gerard!!!!
PERFECT - That works a treat - Just what I was looking for!!
Sometimes strange bits of syntax can be very hard to work out until you
see it working and can learn it.
Thanks again
Ian Whitfield.
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
