Blog – Excel University 18; The IFERROR function of Excel must return the text string "name not in list A" for all "#N/A" errors The steps to apply the VLOOKUP and IFERROR functions (with reference to the current example) are listed as follows I am V Arya, Independent Advisor, to work with you on this issue The double quote used for blanks is wrong Correct that Use below formula =IF (ISBLANK ('CBTS Data'!U2)=TRUE,"", 'CBTS Data'!U2) However, unrelated to #NAME error, you can put your formula as (No TRUE is needed) =IF (ISBLANK ('CBTS Data'!U2),"", 'CBTS Data'!U2) Report abuse
How To Deal With The Name Error In Excel Excelchat
