check if the text in one cell exists in multiple columns

  • Thread starter Thread starter willie
  • Start date Start date
W

willie

hi,

I've got the following question:

I have a sheet with for instance:


A B C D E

1 6 4
2 2
3 3
4 5
5
6


I want to know with a formula if the text in column A exists in column
B-E
Not all text will be in b-e and there will be no specific order. Can
anybody help me with this? i've tried Match, but it can not work with
multiple columns (in my case 10)

ultimatly I would like to use that formula in conditional formatting
to color the cell in column A to green if it exists in column b to
column e

Thanks for all your help
Patrick
 
Back
Top