I have 10 columns/1 row that have different numbers. I want the 11th column
to match for a specific number if found. Here's an example with expected
result

1 2 3 4 X
a c x e 1
t a e k 0
x b i l 1

X=result

Can someone help me with the formula? Thanks!