Excel Reference or VLookup?

[~Brenda]

I am using Excel 2000. I have a spreadsheet that has some
calculations that are simple totaling of columns.

Rather than rekey that total on another spreadsheet, how
do I bring that total over to another page in the same
spreadsheet?

I don't know if this is called a Reference or VLoop (or
neither.)

Thanks,
~Brenda

 

[Aladin Akyurek]

=Sheet1!A10

in a cell on Sheet2 would pick up the value from A10 on Sheet1 if any,
otherwise a 0 will show up.

 

[Don]

-----Original Message-----
=Sheet1!A10

And, if you don't want to show anything when nothing is
present in A10 (or whichever cell is being designated)...

=IF(Sheet1!A10="","",Sheet1!A10)

HTH,

Don

 

[Don Guillett]

And, if sheet1!a10 didn't have anything, what would it show without the
IF???

 

[hgrove]

Don Guillett wrote...

And, if sheet1!a10 didn't have anything, what would it show
without the IF???

...

Why don't you experiment for yourself, and you can report back wit
your discovery. Hint: it won't return ""

 

[Juan Sanchez]

It will be 0 as explaind in the first response...

Juan

 

[BrianB]

1.Select the cell where you want the total
2.Type = sign
3.Select cell that total appears in
4.Press Enter key.
It will change if the source cell changes

 

[Don]

Guess I'm lost here Don.....I only posted the "IF"
formula in case the OP didn't want a "0" showing when the
original cell had nothing in it.....sorry if I confused
anyone or misposted here.

Don

 

[Don Guillett]

No, It was my mis-understanding.

 

[Don Guillett]

Oops, posted wrong place
No, it was my mis-understanding.

 

[Don]

Whewwwwwww......generally it's mine Don....I can rest
easy.....Today anyway.....lol

Don