VLOOKUP NA error

[trianna]

Hello all,

I hope that someone with a brain strong than mine can provide some assistance with VLOOKUP NA errors.

I have Excel tables that I am using the following VLOOKUP formulas on. As expected they return the #N/A error when no data is found.

=VLOOKUP('Outbound Agent Count'!B4, T2Info, 20, FALSE)&", "&VLOOKUP('Outbound Agent Count'!B5, T2Info, 21, FALSE)

=VLOOKUP(C4, T2Info, 18, FALSE)

My need is to have a blank cell returned instead of the #N/A error.

I have tried many things including ISNA and ,””, and nothing is working.

Please help if you can as I am desperate and going bald from pulling my hair out.

Thank you,

Trianna

 

[SteveO59L]

=if(iserror(VLOOKUP(a1,b:d,3,false)),"",VLOOKUP(a1,b:d,3,false))

 

[jmff]

That solution is great!

I have used IFERROR with success too; it is faster than ISERROR because it evaluates VLOOKUP only once.

=IFERROR(VLOOKUP(a1,b:d,3,false),"")