Excel Formula Help Please

[Porcha]

Hi is there a formula to cross reference a name from TAB2 Column H to TAB1 Column C even though they might not be in the same cell, then confirm in TAB1 Column F if there is a match how can I get it to list it as active in Column F? I've used a Countif before but I'm obviously doing something wrong as its not reading how I would like it. Any help appreciated thank you :)

[#2 · Accepted solution]

=IF(ISNA(VLOOKUP(D2,'Tab2'!$H$4:$H$1255,1,FALSE)), "No", "Yes")

All good I got it sorted :) This is what I used if it can help someone else :)