You'll probably need to use VLOOKUP and MATCH to get this to work. I don't
have time to describe it more. Maybe someone else will.

"CMWalsh" wrote:

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