software

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: www.excelforum.com/member.php...foamp;userid=9498
View this thread: www.excelforum.com/showthread...hreadid=543754
Ooops, there was an error in the lookup value on the other sheets.
Nevermind!--
jillteresa
------------------------------------------------------------------------
jillteresa's Profile: www.excelforum.com/member.php...foamp;userid=9498
View this thread: www.excelforum.com/showthread...hreadid=543754