Pull data from multiple sheet
 

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


--
jillteresa
------------------------------------------------------------------------
jillteresa's Profile: http://www.excelforum.com/member.php...fo&userid=9498
View this thread: http://www.excelforum.com/showthread...hreadid=543754

Pull data from multiple sheet
 

Ooops, there was an error in the lookup value on the other sheets.
Nevermind!


--
jillteresa
------------------------------------------------------------------------
jillteresa's Profile: http://www.excelforum.com/member.php...fo&userid=9498
View this thread: http://www.excelforum.com/showthread...hreadid=543754