In Excel, you can reference a cell by naming the top label and side label. With a worksheet that looks like this:

apple pear
one 7 5
two 3 2

So, entering:

=apple one

would = 7

However, I cannot get this to work from another worksheet.

Does anyone know how to reference this from another worksheet? I have tried:

=Sheet1!apple one
=Sheet1!apple Sheet1!one
='Junk.xls]Sheet1'!apple 'Junk.xls]Sheet1'!one

etc. etc.

Any help would be appreciated!