adding iferror to an established formula to avoid #N/A error message

[HeRoseInThree]

I have a formula that works great when the spreadsheet is empty, but when I start adding any data it presents an error.

Is there a way to add iferror to keep the cell blank until the cell has pertinent data?

N&I - BLANK - repair bill - ESTIMATE.xlsx
	O
2	#N/A
Sheet1

Cell Formulas
Range	Formula
O2	O2	=IF(ISBLANK(A19),"",VLOOKUP("tow",A$19:B$38,2,0))

 

[mrshl9898]

Like this? =IFERROR(IF(ISBLANK(A19),"",VLOOKUP("tow",A$19:B$38,2,0)),"")

 

[Fluff]

How about

=IF(A19="","",IFNA(VLOOKUP("tow",A$19:B$38,2,0),""))

 

[JamesCanale]

=ifna(vlookup("tow",A$19:B$38,2,0),"")

 

[HeRoseInThree]

How about

=IF(A19="","",IFNA(VLOOKUP("tow",A$19:B$38,2,0),""))

Thank you!!!!

 

[Fluff]

Glad we could help & thanks for the feedback.