remove the " #N/A" in the results field when the look up field is empty

[Snarf_Master]

I hope my title makes sence. When I copy the Vlookup formula down the column waiting for the lookup field to be entered it shows the "#N/A". How do I make that field blank or hide the "#N/A" until the lookup field is populated?

Thanks!!!

 

[Rick Rothstein]

I hope my title makes sence. When I copy the Vlookup formula down the column waiting for the lookup field to be entered it shows the "#N/A". How do I make that field blank or hide the "#N/A" until the lookup field is populated?

If this is your formula...

=YourFormula

change it to this...

=IFERROR(YourFormula,"")

 

[Snarf_Master]

Thanks

current formula is: VLOOKUP(F3,Sheet2!A:D,4,0)

should it read =IFERROR(F3,Sheet2!A:D,4,0) ??

 

[Joe4]

current formula is: VLOOKUP(F3,Sheet2!A:D,4,0)

should it read =IFERROR(F3,Sheet2!A:D,4,0) ??

No, you aren't replacing your original formula. Rather you are embedding it into an IFERROR formula, i.e.

[COLOR=#ff0000]=IFERROR([/COLOR][COLOR=#0000ff]VLOOKUP(F3,Sheet2!A:D,4,0)[/COLOR][COLOR=#ff0000],"")[/COLOR][COLOR=#333333]
[/COLOR]

See: https://exceljet.net/excel-functions/excel-iferror-function

And By the way, welcome to the Board!

 

[Snarf_Master]

Thank you very much!!!

 

[Joe4]

You are welcome.
Glad we were able to help.