Greeting,
I am apply the following formula, the formula return blank cells as a number instead of returning as blank. Is there a way to fix this, so that it returns just a blank value?
[TABLE="width: 70"]
<tbody>[TR]
[TD="class: xl64, width: 70"]=IF(INDEX(DATA!$D$3:$D$25,MATCH(1,INDEX((DATA!$C$3:$C$25=$B3)*(MID(DATA!$B$3:$B$23,1,2)=MID($A3,2,2))*(DATA!$A$3:$A$25=C$2),0),0))="OK","OK",INDEX(DATA!$B$3:$B$25,MATCH(1,INDEX((DATA!$C$3:$C$25=$B3)*(MID(DATA!$B$3:$B$23,1,2)=MID($A3,2,2))*(DATA!$A$3:$A$25=C$2),0),0)))[/TD]
[/TR]
</tbody>[/TABLE]
https://www.dropbox.com/s/ef9kaipp0ucryyt/BLANKS.XLSX?dl=0
https://www.dropbox.com/s/snmjfvoxc3o9thb/MEE.PNG?dl=0
https://www.dropbox.com/s/auays7a10mb5j1c/MEEE.PNG?dl=0
I am apply the following formula, the formula return blank cells as a number instead of returning as blank. Is there a way to fix this, so that it returns just a blank value?
[TABLE="width: 70"]
<tbody>[TR]
[TD="class: xl64, width: 70"]=IF(INDEX(DATA!$D$3:$D$25,MATCH(1,INDEX((DATA!$C$3:$C$25=$B3)*(MID(DATA!$B$3:$B$23,1,2)=MID($A3,2,2))*(DATA!$A$3:$A$25=C$2),0),0))="OK","OK",INDEX(DATA!$B$3:$B$25,MATCH(1,INDEX((DATA!$C$3:$C$25=$B3)*(MID(DATA!$B$3:$B$23,1,2)=MID($A3,2,2))*(DATA!$A$3:$A$25=C$2),0),0)))[/TD]
[/TR]
</tbody>[/TABLE]
https://www.dropbox.com/s/ef9kaipp0ucryyt/BLANKS.XLSX?dl=0
https://www.dropbox.com/s/snmjfvoxc3o9thb/MEE.PNG?dl=0
https://www.dropbox.com/s/auays7a10mb5j1c/MEEE.PNG?dl=0
Last edited: