Please help..with a formula. I don't know code.

[eagerowl]

I have a long list of numbers - values in a file X, and I want to fin
and replace those values in a even larger list in a file Z an
highlight those values in Z

 

[Frank Kabel]

Hi
not really sure what you're trying to achieve. What do you
want to replace, etc. You may give an example (plain text -
no attachment please)

 

[eagerowl]

I am trying to find a list of combinations in a file "X", in anothe
bigger list in a different file "Z". In fact, both lists can be in th
same file and worksheet. EXAMPLE:

1 2 3 4 5
6 7 8 9 10
11 12 13 14 15
16 17 18 19 20
21 22 23 24 25 ...

each combination of 5 numbers ex. 1 2 3 4 5 in one cell.

Find all those combinations where occur in the file and highlight wit
any color