IFERROR with V-Lookup and ISBLANK

[APerfectCircle]

Hello!

I have an IFERROR, which returns a value from a V-lookup, and iferror, it returns the text "Active". However, some of the fields from the V-lookup are blank and it returns 1/9/1900. Which function can I add so that these cells also the text "Active"? I currently have IFERROR(VLOOKUP,"ACTIVE"). I have tried adding ISBLANK, but I'm not sure if this is what I need.

Thanks in advance

 

[Peter_SSs]

I have an IFERROR, which returns a value from a V-lookup, and iferror, it returns the text "Active". However, some of the fields from the V-lookup are blank and it returns 1/9/1900. Which function can I add so that these cells also the text "Active"? I currently have IFERROR(VLOOKUP,"ACTIVE"). I have tried adding ISBLANK, but I'm not sure if this is what I need.

Try a structure like this
=IFERROR(IF(VLOOKUP="","ACTIVE",VLOOKUP),"ACTIVE")

 

[Aladin Akyurek]

Hello!

I have an IFERROR, which returns a value from a V-lookup, and iferror, it returns the text "Active". However, some of the fields from the V-lookup are blank and it returns 1/9/1900. Which function can I add so that these cells also the text "Active"? I currently have IFERROR(VLOOKUP,"ACTIVE"). I have tried adding ISBLANK, but I'm not sure if this is what I need.

Thanks in advance

Like this:

=T(IFERROR(VLOOKUP(…),"ACTIVE"))