Adapt VBA to skip a row and avoid #N/A

On the attached, I have the following VBA that does an XLOOKUP and returns a corresponding postcode based on an address code in column E

ws2.Range("L2:L" & Range("L999").End(xlDown).Row) = Application.WorksheetFunction.XLookup(Range("E2:E999"), Sheets("ADDRESSES").Range("A2:A102"), Sheets("ADDRESSES").Range("E2:E102"))

This is working other than I am getting a #N/A in column L every other row because of the way my spreadsheet populates. I need to adapt the VBA so that it ignores every other row and avoids the #N/A error. I'm not sure how to adapt my range to do this.

Any help is greatly appreciated.

use the Fourth argument of the function, which is the value to return if not found.

Please Login or Register  to view this content.