Cross referencing named row with named column

D

davide212

I'm trying to find a way to cross reference a column named June with a row
named Sales but cant figure out what the syntax is. I thought it used to be
=June|Sales but it doesnt seem to work.
 
D

duane

there is probably an easier way but this finds the value in the cell o
the intersection

=OFFSET(A1,ROW(sales)-1,COLUMN(june)-1,1,1
 
J

James R-S

Space.

Your formula should use a space rather than the pipe.

"=June Sales"

(As an aside, take a look at Insert->Name->Create as it helps create row and
column names in tables which you can then you the space intersection formula
to pull values out of the table.)

James R-S.
 
Top