What I have:
A1: 1 B1:3
A2: 2 B2:5
A3: 3 B3:10
A4: 4
A5: 5
A6: 6
A7: 7
I have 2 colums in Excel, A1 to A7 with values 1-7. I have second colum B1 to B3 with 3, 5, 10
I would like the excel to use compare List B to List A, and tell if if the value in the List B exists in List A.
I have found “=or(exact(B1,A1:A7))” function, but it quite doesn’t work for me.
Thanks advance