One way, entered in B2 of Sheet2 (entered w/Cntrl+Shift+Enter):

=IF(OR(VLOOKUP($A2,Sheet1!$A$1:$D$3,{2,3,4},0)=B$1 ),"Y","")


"PJS" wrote:

Hi ^_^

I was wondering how to achieve this. Any help or input would be great.
Thank you.

Sheet1 ~ data source
Type/Value
A 1 2 3
B 2 4 6
C 1 3 6

Sheet2
1 2 3 4 5 6
A Y Y Y
B Y Y Y
C Y Y Y