Linking Information in Sheets based on its content

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to link information in several worksheets so that if I change the
information on the first one, then the others would be updated. My first
worksheet includes various phone numbers (home & mobile). If there is a
phone number available, it links properly - however, if they do not have a
number, then the value comes up as "0". I would rather have the entry blank.
What formula would I use? Currently, it is set up as 'Worksheet1'!B2.
Would it be an "IF/OR" function?

Thank you for your assistance.
 
You could use conditional format so that the foreground colour is set
to the same colour as the background if the cell contents are equal to
zero. Alternatively, the formula;

= IF(Worksheet!B2 = "", "", Worksheet!B2)

Pete
 
You must log in or register to reply here.

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

Similar Threads

I need a cell to be blank. 4
Returning value in secocolumn based on selected value in first col 1
Linking Between Sheets and #Value! Error 6
link values from same cell of 20 worksheets into column on one she 3
Linking to information within a cell 5
How do I use the text content of a cell as a worksheet reference? 9
Returning a Value from Another Worksheet 2
Linking value of cell on one worksheet to a column on another work 1

Back
Top