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