#N/A to blank

[GAcuren]

So how can I write this formula to show a blank vs. #N/A

my formula is: =IF(C49>0,LOOKUP(C49,EQUIPMENT!D$4:D$62,EQUIPMENT!C$4:C$62),"")

just don't know what to add to it to be blank until dependable cell is populated. Any help would be greatly appreciated.

 

[SunnyAlv]

Like this ?

=IFERROR(IF(C49>0,LOOKUP(C49,EQUIPMENT!D$4:D$62,EQUIPMENT!C$4:C$62),""),"")

 

[Alex Blakenburg]

Is your formula actually doing what you are intending ?
The "Lookup" function needs the list to be sorted.

Try this:

=IF(C49>0,XLOOKUP(C49,EQUIPMENT!$D$5:$D$62,EQUIPMENT!$C$5:$C$62,""),"")

 

[Joe4]

Like this ?

=IFERROR(IF(C49>0,LOOKUP(C49,EQUIPMENT!D$4:D$62,EQUIPMENT!C$4:C$62),""),"")

Better to use the IFNA function instead of IFERROR in this case.

Why? The IFNA function only affects #N/A values.
IFERROR is a "catch-all" that will affect all errors. So it could hide/ignore errors others than #N/A that you may want/need to know about!

 

[SunnyAlv]

Lebih baik menggunakan fungsi IFNA daripada IFERROR dalam kasus ini.

Mengapa? Fungsi IFNA hanya mempengaruhi nilai #N/A.
IFERROR adalah "catch-all" yang akan mempengaruhi semua kesalahan. Jadi itu bisa menyembunyikan/mengabaikan kesalahan selain #N/A yang mungkin ingin/perlu Anda ketahui!

Thanks for the correction @Joe4

 

[Joe4]

Thanks for the correction @Joe4

No problem.

It isn't that your formula is wrong - it will work. It just may have some unintended consequences too, since IFERROR is so broad.
IFNA zeroes in on just that error and nothing else.