Pull data from multiple sheet

  • Thread starter Thread starter jillteresa
  • Start date Start date
J

jillteresa

Hi all,
I have a lookup formula in sheet1 that pulls from 'Grand Total' - I
need the same data pulled from 26 other sheets. Here is the formula:

=INDEX('Grand Total'!$G:$G,MATCH(C$1,'Grand Total'!$B:$B,0)+2)

Normally I would use a find/replace with the sheet name, but for some
reason this is returning error messages. I've tried to manually adjust
as well - not working. For some reason I am losing the little ' '
around the sheet name when I press enter.

Help please?
Jill
 
Ooops, there was an error in the lookup value on the other sheets.
Nevermind!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivotting - T. Valko 1
Pivot from multiple sheets 1
Pulling From Multiple Sheet 0
Scrabble Value calculation for Welsh words 0
Retrieving values from another sheet 1
if > < on one tab - want total on a summary sheet 3
Pulling/Collating Data from Workbooks 6
Need Formula For Data Summary 7

Back
Top