iferror returns #Name? instead of string

Question

IFERROR function returns "#NAME?" instead of string "National"

Below is the code.Please anyone help me out

Range("AK2:AK" & ORCA_7point5_Count).FormulaR1C1 = _ "=IFERROR(IF(RC[-34]=VLOOKUP(RC[-34],'State;National'!C[-36],1,0),RC[-26]),"National")"

Thanks in advance

mine is office 360 Pro. Daniel ans gave the solution. thanks for helping — Sahana G, Mar 15 '19 at 11:37

Daniel · Accepted Answer · 2019-03-15T14:19:33.293

1

I didn't validate your formula, but this would be a syntax error for a start because you missed quotation marks: ""National""

edited Mar 15 '19 at 14:19

answered Mar 15 '19 at 10:46

Daniel

thanks @daniel it solved the issue. Should use ""text"" – Sahana G Mar 15 '19 at 11:36

1 Answers1