Vlookup

[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)?

 

[Domenic]

Hi,

Try,

=ColumnHeading RowHeading

Hope this helps!

 

[nc]

I was looking for something more like a lookup function.

Plus your method don't seem to work.

Thanks for trying.

 

[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

 

[nc]

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

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

 

[Alan Beban]

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

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

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

 

[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
.