Why Does Formula Return "0"

[meppwc]

I use this formula to perform a lookup of a serial number. Sometimes it returns "0".
What condition would cause this and is there a logic that can be added to this formula to statue what is truly taking place?
=IFERROR(XLOOKUP(C4,'AL LOOKUP'!B:B,'AL LOOKUP'!A:A),"NOT IN AL")

 

[Fluff]

You could get a zero if the the value of C4 is found in col B & col A either contains a zero, or is blank.
Try

=let(x,XLOOKUP(C4,'AL LOOKUP'!B:B,'AL LOOKUP'!A:A,"NOT IN AL"),if(x="","no data",x))

 

[meppwc]

That helps............I have discovered that all of the times where "0" is returned, column A is blank. Is there an update that you can suggest to this formula when A is blank, it returns "STATUS UNKNOWN"?

 

[Fluff]

Just change no data in the formula I posted to read "STATUS UNKNOWN"

 

[meppwc]

I should have figured that one out on my own. But I am very grateful for your assistance.

 

[Fluff]

You're welcome & thanks for the feedback.