Referencing a cell on a different sheet....

B

Brightbelt

Hi,
I used to use Excel in Windows and I need to reference a cell and its value
on another sheet (same workbook etc).

In windows, it was something like:
!=sheet2(A33)

But this does not work on the iMac. Could someone help me learn this formula
for the Mac?

Many Thanks, Frank B.
 
B

Brightbelt

Ok, I got it....my apologies. I had it wrong. It is:
=sheet3!A33

No wonder it was not working - I had the exclamation mark placed wrong.
Thanks, Frank B.
 

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

Top