Forum Discussion

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

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

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.