Ask Your Question

Revision history [back]

Sounds like you want to define column and row labels and ranges under menu Insert->Names->Labels and then in a formula simply use

=columnlabel rowlabel

If labels contain blanks enclose them in single quotes

='column label' 'row label'

You can also use the technically equal ! intersection operator

=columnlabel!rowlabel