intersection naming

B

BorisS

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?
 
P

paul

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?
 
M

Max

Try indirect, eg: in say, A19:
=INDIRECT(A17) INDIRECT(A18)
where A17 houses the col header name,
A18 contains the row header name
 
Top