Vlookup with Match and Iferror for confirming is values exist in a column

[Mr.Magoo]

Purpose: Want to look up the card-id number in column A in column H and return a yes or no in Column L.

SEE attached workbook and tab [TEST DATA]

Failed attempts use:

1.
=IFERROR(IF(MATCH(A3,$H$3:$J$102,0),"yes",),"no")

result: always returns a [no] result

2.
=IF(ISNA(VLOOKUP(A3,Sheet1!F8:H107,1,FALSE)),"NO","YES")

result: always returns a [no] result

Requirement: PLease advise how to achieve the purpose of this exercise either by correcting the above formula or applying an alternative method to produce the same result

[samba_ravi]

=IFERROR(IF(MATCH(A3,$H$3:$J$102,0),"yes",),"no") Change as
=IFERROR(IF(MATCH(A3,$H$3:$H$102,0),"yes",),"no")

[FlameRetired]

Also change:

=IF(ISNA(VLOOKUP(A3,Sheet1!F8:H107,1,FALSE)),"NO","YES")

to:

=IF(ISNA(VLOOKUP(A3,$H$8:$H$107,1,FALSE)),"NO","YES")