How do I make the #N/A not populate a cell?

[Marq]

Excel 2007

I have the formula below in a cell.....the formula is providing me a name of a person based on an associated number.....for instances where there is no number, no name is required so I get the "#N/A" result.....what do I put in the formula to make the #N/A disappear?

Here is the formula:

=INDEX($B$4:$B$15,MATCH(G7,$A$4:$A$15,0),1)

 

[MrKowz]

You need to use an error handler:

Excel 2003 or older:
=IF(ISERROR(INDEX($B$4:$B$15,MATCH(G7,$A$4:$A$15,0),1)),"",INDEX($B$4:$B$15,MATCH(G7,$A$4:$A$15,0),1))

Excel 2007 or newer:
=IFERROR(INDEX($B$4:$B$15,MATCH(G7,$A$4:$A$15,0),1),"")

Note: I highlighted your formula in blue so you can easier see what I added to the formula.

 

[VoG]

Try

=IF(ISNA(INDEX($B$4:$B$15,MATCH(G7,$A$4:$A$15,0),1)),"",INDEX($B$4:$B$15,MATCH(G7,$A$4:$A$15,0),1))

 

[Marq]

You need to use an error handler:

Excel 2003 or older:
=IF(ISERROR(INDEX($B$4:$B$15,MATCH(G7,$A$4:$A$15,0),1)),"",INDEX($B$4:$B$15,MATCH(G7,$A$4:$A$15,0),1))

Excel 2007 or newer:
=IFERROR(INDEX($B$4:$B$15,MATCH(G7,$A$4:$A$15,0),1),"")

Note: I highlighted your formula in blue so you can easier see what I added to the formula.

using 2007

and it works perfect!..thanks!