Excel 2016: VBA Code to check if a value exists in a Table Column

[ajay_gajree]

Can anyone tell me or point me to a link that can tell me how to check if a value exists in a Table Column?

I know how vlookup, is similiar?

Application.VLookup(x, Worksheets("Module").ListObjects("tbl1").Range, 8, False)

 

[wideboydixon]

If Not IsError(Application.Match(x, Worksheets("Module").ListObjects("tbl1").ListColumns("ColumnHeadText").Range, 0)) Then
    Debug.Print "Value exists"
Else
    Debug.Print "Value does not exist"
End If

WBD