Consolidate Workbook

[dragonmouse]

I'm trying to consolidate certain fields across my workbook:

I'm using a formula: IF('Week 42'!D145,'Week 42'!D145," ")

I want this formula to return whatever is in cell D145 on the "Week 42" workseet to cell D145 on he "Consoliated" worksheet OR if the cell is blank, I want it to remain "blank". It seems simple but it's returning only "VALUE#"

 

[Richard U]

try:

IF('Week 42'!D145 <> "",'Week 42'!D145," ")

 

[Fluff]

How about
=IF('Week 42'!D145="","",'Week 42'!D145)

 

[jkpieterse]

If the formula you posted returns #Value ! then that is what is in the cell D145 on the Week 42 sheet.

 

[Fluff]

@jkpieterse
You'll also get that if D145 is text

 

[dragonmouse]

PERFECT. The "<>" worked. THANK YOU. The "=" worked to get rid of the "VALUE#" but it returned a "0" instead of a BLANK

 

[jkpieterse]

@Fluff Of course.