I am trying to use VB and my code is
Range("E4:E17").Value = IF(ISNA(WorksheetFunction.VLookup(Range("B4:B17"), Worksheets("Placeholder").Range("C2:F202"), 2, False)),0,WorksheetFunction.VLookup(Range("B4:B17"), Worksheets("Placeholder").Range("C2:F202"), 2, False))
I have problem... it shows expected expression in beginning of the IF statement... Pls help
but this one is working. Without ISNA...
Range("E19:E58").Value = WorksheetFunction.VLookup(Range("B19:B58"), Worksheets("Placeholder").Range("C2:F202"), 2, False)
Bookmarks