I am using
code in Excel 2007 and 2010 .But I want to use ISERROR in Excel 2003 as below![]()
Cells(Row, 2).FormulaR1C1 = "=IFERROR(VLOOKUP(RC1,Sheet2!R1C1:R" & LR & "C2,2,False),""Not Found"")"
But NOT WORKING.![]()
Cells(Row, 2).FormulaR1C1 = "=IF(ISERROR(VLOOKUP(RC1,Sheet2!R1C1:R" & LR & "C2,2,False)),""Not Found"",VLOOKUP(RC1,Sheet2!R1C1:R" & LR & "C2,2,False))"
How can I modify the code for Excel 2003 ?
Thanks in advance for any reply and help.
Regards,
turist
Bookmarks