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

dont quite follow.the address function work like that using a number for the
row and column where row 1 is the first row in the worksheet (ussually 1) and
column 1 is the first column(ussually A).
Does that help?
--
paul

remove nospam for email addy!



"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

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