VBA vlookup if value not found

[wasntme]

Hello,

I have this bit into my code, that should return simple "Yes", "No" values present in the range.

inclusion = Application.VLookup(Dest, details, 10, False)

All variables are defined, inclusion as Variant, Dest as String, details as Range.

The problem i am encountering is that when the lookup value is not present, the return value is a "Yes", which messes with the further logic of the code.

I can write a separate IF to check it, but was wondering if there is a more simple way to solve this.

Thanks.

 

[Fluff]

If "Dest" is not found then "inclusion" will be an error, not "Yes"

 

[wasntme]

Hi, yes maybe i wasn't clear enough. Anyway i have fixed it, added one IsError check.

 

[Fluff]

Glad you sorted it & thanks for the feedback