Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |