Blank cells returning 0 (zero) value with INDEX

**jobdillon** · 10-13-2014, 12:31 PM

I need to merge data from one worksheet to another. I am using INDEX, MATCH functions, which work fine except that when a match is found and the cell is blank, the value returned and placed in the merged cell is 0.

I want the merged cell to be blank, same value as the original cell.

Here is the function that I am using:

Please Login or Register  to view this content.

Thanks in advance for your time.

**daddylonglegs** · 10-13-2014, 12:36 PM

What sort of values does the formula return? If they are text values then this small change will give you a blank instead of a zero

=IFERROR(INDEX('[worksheet_with_info_to_merge]'!$A:$T,$X2,MATCH(P$1,'[worksheet_with_info_to_merge]'!$A$1:$T$1,0))&"","-")

.......but if you are returning numbers that will convert them to text formatted numbers

**jobdillon** · 10-20-2014, 10:39 AM

Thanks for taking the time to respond to my post and render assistance. Unfortunately, what happens when I add &"" to the formula, making the formula

Formula:

Please Login or Register  to view this content.

is that the cell now displays the formula rather than the result.

**jobdillon** · 10-20-2014, 10:47 AM

Sorry for the misstatement! The display of the formula rather than the result is not because I added &"". I copied the original formula into a new blank cell, modified it and got the result that I wanted. I'm not sure if the problem is related to the worksheet password protection or something else.