Question
Provide an example VBA code snippet demonstrating how to use `IsError` to handle a `VLOOKUP` error and return a default value.
Asked by: USER3475
126 Viewed
126 Answers
Answer (126)
```vba
Dim result As Variant
result = WorksheetFunction.VLookup(lookup_value, lookup_table, index_num, [range_lookup])
If IsError(result) Then
result = "Not Found"
End If
```