Try indirect, eg: in say, A19:
=INDIRECT(A17) INDIRECT(A18)
where A17 houses the col header name,
A18 contains the row header name
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"BorisS" wrote:
I'm trying to use an intersection for a cell. I want the first term to be
the value that shows up in one cell and the second term to be the value from
another cell. I'm having trouble figuring out how to use the single quotes
that are needed, along with the value of the cell. Any help?
--
Boris