How do I get rid of the #N/A?

[agoodson1956]

I am using this formula =IF(E2<>"",INDEX(TRAVEL!$B:$H,MATCH(E2,TRAVEL!$F:$F,0),4),"") but the city is not found so I am getting a #N/A how do I get rid of it?

 

[sheetspread]

Iferror for versions 2007 and later, otherwise if(iserror(......

 

[vds1]

Try,

=IF(E2<>"",IFERROR(INDEX(TRAVEL!$B:$H,MATCH(E2,TRAVEL!$F:$F,0),4),""),"")

 

[agoodson1956]

Thank you! I could not figure it out.