Look up based on Column and Row headings

[AD108]

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.

 

[Guest]

Try something like this:

With
Your source list in A13
Your formula list in A1113

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

 

[RagDyeR]

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!
=====================================================

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]

Thanks alot, that works well.

 

[RagDyer]

Appreciate the feed-back.