Match/Index

[DPD013]

Hello,

I have a sheet with rows (colors) and columns (names), depending on the combination there is a N or Y, Im looking for a formula which would look at the values on both rows and columns and return either Y/N. A2:A94 color and B1:K1 names. Thank you.

 

[Oeldere]

=index($a$1:$k$94,match(z1,$a$1:$a$94,0),match(z2,$a$1:$k1$1,0))

in which

z1 is a value with an color
z2 is a value with an name