Vlookup

N

nc

Is there a lookup function that can find the intersection
value of a specified column and row based on their
headings (column and row)?
 
N

nc

I was looking for something more like a lookup function.

Plus your method don't seem to work.

Thanks for trying.
 
P

Peo Sjoblom

It works,

you need to check accept labels in formulas under tools>options>calculation


Otherwise you can use

=INDEX(A1:N50,MATCH(Rowheading,A1:A50,0),MATCH(Columnheading,A1:N1,0))

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
N

nc

Thanks Peo. It was the Index function I was looking for.

Does the first method work with number as the column/row
heading?
 
A

Alan Beban

nc said:
Thanks Peo. It was the Index function I was looking for.

Does the first method work with number as the column/row
heading?
Click to expand...

Not directly; numbers are not acceptable names for ranges. For example,
with 3 as the heading, the accepted heading will be to _3

Alan Beban
 
N

nc

Thanks for your help.
-----Original Message-----


Not directly; numbers are not acceptable names for ranges. For example,
with 3 as the heading, the accepted heading will be to _3

Alan Beban
.
Click to expand...
 
Top