INDEX/MATCH across several worksheets

Hi

I have come across another thread on this site when trying to google for an answer as I cannot get the formula quite correct as it is returning an error message. The previous thread now has SOLVED in the title so have started a new thread.

From the screenshoots attached you will see that I have a template that gets filled in with the details of the license. This is the one where the company name is V at the top. There can be upto 30 of these templates in the workbook all in the same layout. I am trying to get the data into the summary sheet so that it can be viewed easily. The summary sheet is the one with coloured titles.

So for example in e3 in the summary sheet is "24". I would like this to be populated from the info entered into c7 in the licence sheet.

I hope that this makes sense and thanks for advance with any info.

V Licence.JPG
Summary.JPG

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi

I have attached a sample spreadsheet with a before and after Summary sheet. The after summary sheets get the data from the sheets V & O which are set in the same format. There could be up to 30 sheets like V & O in the workbook.

in E2

=IFERROR(INDIRECT("'" & $A2 &"'!$C$5"),"")

IN F2 to H2 change $C$5 to $C$6, $C$7 and $C$8

copy formulae down

That works a treat - many thanks

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.