Forum Discussion

Deann1971's avatar
Deann1971
Copper Contributor
Jan 10, 2019

Importing cell info from another sheet

I have several questions, because I am an Excel learner.  No expert.   On Sheet1, I'm using the function/formula ='Sheet2'! along with the cell number I'm trying to pull info from and pulling it in...
excel
Formulas and Functions
JWR1138's avatar
JWR1138
Iron Contributor
Jan 10, 2019

For question 1 a blank cell defaults to 0 when pulled like that, you can either change cell formatting to format 0 as blank or write your formula as =IF(Sheet2!A1<>0,Sheet2!A1,"").

 

For question 3, yes, this depends on how exactly you would want this displayed in a single cell. 

 

I don't entirely understand what you are asking for question 2, if sheet 2 has a specific value in a cell then you want it to read as "X"?

  • Deann1971's avatar
    Deann1971
    Copper Contributor
    Jan 11, 2019

    Thank you for the reply!
    Question 1: I didn't get time today, but I will try this.
    Questions 2: yes, Sheet 1, is a work order and X's a box for a specific machine process
    Question 3: Usually, the range of cells I'm pulling from only has something in one of the cells, so it wouldn't be pulling info from multiple cells...just looking at which one to pull from...I hope that makes sense.

Resources