vlookup to return NONE instead of #n/a

[mdkusername]

Excel 2016
I would like the vlookup cell to have NONE instead of #n/a.
I was able to get it to return a 0, but can't seem to get it to return NONE.

 

[Aladin Akyurek]

Care to post the formula?

 

[mdkusername]

=iferror(vlookup(a7,aaa!a17:c48,3,false),0)

 

[Aladin Akyurek]

=iferror(vlookup(a7,aaa!a17:c48,3,false),0)

Like this:

=IFERROR(VLOOKUP(A7,aaa!$A$17:$C$48,3,FALSE),"NONE")

 

[sandy666]

choose:
=iferror(vlookup(a7,aaa!a17:c48,3,false),"")
or
=iferror(vlookup(a7,aaa!a17:c48,3,false),"NONE")

u can use =IFNA(your_vlookup,"NONE") instead of IFERROR()

 

[AhoyNC]

Try:
=iferror(vlookup(a7,aaa!a17:c48,3,false),"NONE")

 

[mdkusername]

Tried that and still get 0

 

[mdkusername]

I will try it out

 

[AhoyNC]

Are you sure that the VLOOKUP is returning #N/A and not 0?