Formul ? ,0),"")

[zone709]

Hi using this formula if nothing found return 0

I would like to change it if it finds nothing to return blank not 0

=IFERROR(VLOOKUP($H$3:$H$100, Data!$D$2:$AH$100,25,0),"")

Thanks

 

[zone709]

Returns #N/A Didn't think it would be like to just not return 0

 

[Joe4]

Is that because H3 does not have a match?
So it sounds like you have two things going on, values that have no matches, and matches that have blanks in the column you are returning. And you want to return a blank in both instances, is that right?
We should just be able to wrap the last formula I posted in an IFERROR to handle those non-matches, i.e.

[COLOR=#333333]=IFERROR(IF(LEN(VLOOKUP([/COLOR][COLOR=#000000]$H3,Data!$D$2:$AH$100,3,0))=0,"",VLOOKUP($H3,Data!$D$2:$AH$100,3,0)),"")[/COLOR][COLOR=#000000]

[/COLOR]

 

[Aladin Akyurek]

​number

In that case, you can try:

=IF(ISNUMBER(1/VLOOKUP($H$3:$H$100,Data!$D$2:$AH$100,25,0)),VLOOKUP($H$3:$H$100,Data!$D$2:$AH$100,25,0),"")_{^{<strike>
</strike>}}

 

[zone709]

Done if works fine thanks for the help