Getting this error *BC30198: ‘)’ expected* on write cell with vlookup

[lrtetala (Lakshman Reddy)]

Hi @xiaozhuang-susan.wei

Welcome to Community!

Try this

formula = “=IFERROR(VLOOKUP(A2,‘[Source1Excel. sheet.xlsx]Sheet1’!$A:$B,2,FALSE),”“NOT FOUND”“)”