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