Find Match based on list

[DBaker7777]

I have a list of products on Sheet 1 column A. On sheet 2 I have data and in column A are various products. What I need is to look up each product on Sheet 1 and then for each instance it appears in Sheet 2 I need to update 9 columns over to a Yes each time it finds the name. Any help is appreciated.

 

[kweaver]

Why doesn't this work, then? Filled down.

=IF(ISNUMBER(MATCH(A2,Sheet1!$A:$A,0)),"YES","NO")

 

[DBaker7777]

Why doesn't this work, then? Filled down.

=IF(ISNUMBER(MATCH(A2,Sheet1!$A:$A,0)),"YES","NO")

Because the data in Sheet 2 is pasted each day and the values from Sheet 1 could change from week to week. Just thought I could find a way that as names are added to sheet 1 it would just look through Sheet 2 and change those values to yes.

 

[DBaker7777]

Nevermind scratching this plan. Thank you for any assistance