Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Intersection of row and column based on input
I have a problem. I am trying to get a function to return a value from a
table on a different worksheet. Here is a small example of my spreadsheet: Table with Data Keyed in called Input Sheet: May-06 Jun-06 Jul-06 Aug-06 Rev S&W T&E Promo My Output sheet is called By Month. The column and row headings are the same. What I am looking to do is have the output sheet find the data on the input sheet based on what month I specify. For instance, on the output sheet, cell A3 is where I put in what month I want the formula to reference. So if I type in Jan-06, I want the formula to see that and return the value where Rev interesects with Jan-06 from the input sheet. Hopefully you can help me out. -- Thanks, Chris |