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