Look up based on Column and Row headings
 

Hello,

I am trying to write a "look up" that will return the cell value where the
row and column headings in the range match the row and column headings in
the source range.

So if I had the source range:

apples oranges pears
Jan 500 600 700
Feb 400 300 200
Mar

And formula range:

Jan Feb Mar
apples (formula here)
oranges
pears

Where it says "formula here", I want it to return 500.

Thanks in advance for any help on this.

--
AD108

Look up based on Column and Row headings
 

Try something like this:

With
Your source list in A1:D3
Your formula list in A11:D13

B12: =VLOOKUP(B$11,$A$11:$D$13,match($A12,$A$1:$D$1,0))

In that formula would find "jan" in the source list and return the value
from the same column that contains "apples"

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"AD108" wrote:

Hello,

I am trying to write a "look up" that will return the cell value where the
row and column headings in the range match the row and column headings in
the source range.

So if I had the source range:

apples oranges pears
Jan 500 600 700
Feb 400 300 200
Mar

And formula range:

Jan Feb Mar
apples (formula here)
oranges
pears

Where it says "formula here", I want it to return 500.

Thanks in advance for any help on this.

--
AD108

Look up based on Column and Row headings
 

Say you original datalist is in A1 to D4,
with months in A2 to A4,
and products in B1 to D1.

Say your lookup list is in K1 to N4,
with months in L1 to N1,
and products in K2 to K4.

Enter this formula in L2 and copy across to N2,
then copy down to N4:

=INDEX($A$1:$D$4,MATCH(L$1,$A$1:$A$4,0),MATCH($K2, $A$1:$D$1,0))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"AD108" wrote in message
...
Hello,

I am trying to write a "look up" that will return the cell value where the
row and column headings in the range match the row and column headings in
the source range.

So if I had the source range:

apples oranges pears
Jan 500 600 700
Feb 400 300 200
Mar

And formula range:

Jan Feb Mar
apples (formula here)
oranges
pears

Where it says "formula here", I want it to return 500.

Thanks in advance for any help on this.

--
AD108

Look up based on Column and Row headings
 

Thanks alot, that works well.


--
AD108
"RagDyeR" wrote in message
...
Say you original datalist is in A1 to D4,
with months in A2 to A4,
and products in B1 to D1.

Say your lookup list is in K1 to N4,
with months in L1 to N1,
and products in K2 to K4.

Enter this formula in L2 and copy across to N2,
then copy down to N4:

=INDEX($A$1:$D$4,MATCH(L$1,$A$1:$A$4,0),MATCH($K2, $A$1:$D$1,0))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"AD108" wrote in message
...
Hello,

I am trying to write a "look up" that will return the cell value where the
row and column headings in the range match the row and column headings in
the source range.

So if I had the source range:

apples oranges pears
Jan 500 600 700
Feb 400 300 200
Mar

And formula range:

Jan Feb Mar
apples (formula here)
oranges
pears

Where it says "formula here", I want it to return 500.

Thanks in advance for any help on this.

--
AD108

Look up based on Column and Row headings
 

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"AD108" wrote in message
...
Thanks alot, that works well.


--
AD108
"RagDyeR" wrote in message
...
Say you original datalist is in A1 to D4,
with months in A2 to A4,
and products in B1 to D1.

Say your lookup list is in K1 to N4,
with months in L1 to N1,
and products in K2 to K4.

Enter this formula in L2 and copy across to N2,
then copy down to N4:

=INDEX($A$1:$D$4,MATCH(L$1,$A$1:$A$4,0),MATCH($K2, $A$1:$D$1,0))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"AD108" wrote in message
...
Hello,

I am trying to write a "look up" that will return the cell value where
the
row and column headings in the range match the row and column headings in
the source range.

So if I had the source range:

apples oranges pears
Jan 500 600 700
Feb 400 300 200
Mar

And formula range:

Jan Feb Mar
apples (formula here)
oranges
pears

Where it says "formula here", I want it to return 500.

Thanks in advance for any help on this.

--
AD108