[LUG] Spreadsheet help

[Pentiddy <pentiddy@xxxxxxxxxxxxxx>]

I have a fairly specific question to anyone who is an experienced 
spreadsheet user.

I have a column of data in a spreadsheet which relates to co-ordinates 
on a grid (xx,yy).
What I would like to do is 'map' those co-ordinates on a spreadsheet- 
i.e translate xx,yy to a cell co-ordinate. Ideally I would be able to 
place information from another column on the data into the identified cell.
I feel like this should be possible, and have looked through functions 
and searched the internet but have not found even a starting place.

Any help would be gratefully received.

I am using Libreoffice Calc but assume most spreadsheets will have 
similar functionality unless we move into the realms of Macros and VBA...

Thanks

Anthony

--
The Mailing List for the Devon & Cornwall LUG
https://mailman.dcglug.org.uk/listinfo/list
FAQ: https://www.dcglug.org.uk/faq/