Excel Reference or VLookup?

  • Thread starter Thread starter ~Brenda
  • Start date Start date
B

~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
 
=Sheet1!A10

in a cell on Sheet2 would pick up the value from A10 on Sheet1 if any,
otherwise a 0 will show up.
 
-----Original Message-----
=Sheet1!A10
Click to expand...

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 wrote...
And, if sheet1!a10 didn't have anything, what would it show
without the IF???
Click to expand...
...

Why don't you experiment for yourself, and you can report back wit
your discovery. Hint: it won't return ""
 
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
 
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
 
Back
Top