Thread: Lookup Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Curtis Curtis is offline
external usenet poster
 
Posts: 181
Default Lookup Question

I have a summary sheet that lists all divisions across the top (d7:q7)
It lists all GL accounts A3:A127
Also cell c3 is reserved for mth (numerically entered 1 thru 12)

My source workbook contains 12 sheets (each sheet representing a month)
-divisions are listed across the top (d7:q7)
-G/L accounts A3:A127
-costing d3:q127

Is than any formula that could look through all the sheets based on the
month number entered in cell c3 in the summary sheet. ( for example if 4 is
selected it would look for the worksheet representing the 4th month

Thanks