• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Indirect formula help

Hi,

I have number of worksheets named "Data entry (1)", "Data entry (2)" ................ I have to prepare the summary sheet reflecting revenue and net profit for each company in the summary sheet. I am trying to put Indirect formula to get the numbers in the summary sheet but no luck. Can you please help.

=INDIRECT("'Data entry*" & ADDRESS(MATCH(A6,#REF!$A:$A,0),MATCH($B$4,#REF!$F:$F,0)))

Thanks
 

Attachments

  • consol 14 Apr.xlsm
    93.5 KB · Views: 7
Your setup is confusing. It looks like you're trying to use the labels in col A to figure out which sheet to grab, but the sheets have the non-descriptivate labels of "Data entry (7)" rather than "Data entry QBQ".

IMO, I'd change the workbook design. First, get all the raw data on a single sheet and use formulas and pivots to split it out. I'd also probably move all the hard coded items together and put the formula columns to the right, so my users can easily type or copy in their data.
 

Attachments

  • Report Example.xlsx
    96.7 KB · Views: 9
Back
Top