Look up based on Column and Row headings

A

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

Ron Coderre

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
 
R

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top