# Need Help For Formula to Return Zero If No Match

#### CARBOB

##### Well-known Member
Is it possible to have the formula in J48 return a blank, if there is no match/
Excel Workbook
J
48#N/A
491097
75%
Excel 2007
#VALUE!
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

### Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

#### martindwilson

##### Well-known Member
just put iferror around it

=iferror(MATCH(1,(DRAWS!\$R\$20:\$R\$4839=\$B48)*(DRAWS!\$S\$20:\$S\$4839=J\$42),0)-1,"") for blank
or
=iferror(MATCH(1,(DRAWS!\$R\$20:\$R\$4839=\$B48)*(DRAWS!\$S\$20:\$S\$4839=J\$42),0)-1,0) for 0

#### steve the fish

##### Well-known Member
=IFERROR(formula,"")

#### CARBOB

##### Well-known Member
I knew you'll would come thru!! Thank you very much.

just put iferror around it

=iferror(MATCH(1,(DRAWS!\$R\$20:\$R\$4839=\$B48)*(DRAWS!\$S\$20:\$S\$4839=J\$42),0)-1,"") for blank
or
=iferror(MATCH(1,(DRAWS!\$R\$20:\$R\$4839=\$B48)*(DRAWS!\$S\$20:\$S\$4839=J\$42),0)-1,0) for 0

#### CARBOB

##### Well-known Member

just put iferror around it

=iferror(MATCH(1,(DRAWS!\$R\$20:\$R\$4839=\$B48)*(DRAWS!\$S\$20:\$S\$4839=J\$42),0)-1,"") for blank
or
=iferror(MATCH(1,(DRAWS!\$R\$20:\$R\$4839=\$B48)*(DRAWS!\$S\$20:\$S\$4839=J\$42),0)-1,0) for 0

Trying to get this formula to return a blank instead of zero.
Excel Workbook
AA
22107
F536 DB
Excel 2007
#VALUE!
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

#### XOR LX

##### Well-known Member
Hi.

=IFERROR(1/(1/(SUMPRODUCT(--(\$J\$2:\$J\$376993=\$S22),(--(\$I\$2:\$I\$376993=AA\$21))))),"")

Regards

Many thanks.

You're welcome.

Replies
1
Views
52
Replies
1
Views
34
Replies
0
Views
68
Replies
24
Views
237
Replies
17
Views
247