Matching Table Arrarys

Hello everyone,

I am attempting to have Excel search through a column array and return values that match my lookup value. I don't care if the values are in a particular order within the array, I just want to know that the values are in there. Here's an example of what I'm referring to.

Sheet1 A1:A10 matching it with Sheet2 F1:F10, where Sheet1 A1 contains my lookup value and Sheet2 contains my table array. I've tried the formula and it did not work:

IF(ISNA(VLOOKUP(Sheet 1 A1,F1:F10,1,FALSE)),"No","Yes")

I appreciate your help with this.

Thank you,
Jessica

Try it like this in B1 of Sheet1:

=IF(ISNA(MATCH(A1,Sheet2!$F$1:$F$10,FALSE)),"No","Yes")

then copy down.

Hope this helps.

Pete