find or vlookup or dlookup?

[eagerowl]

I have a list like this on a worksheet:
( each set of 5 numbers in a cell. example:
a1 [ 1 2 3 4 5 ]
a2 [ 1 3 4 5 6 ]
a3 [ 1 4 5 6 7 ]
a4 [ 1 4 5 6 7 ]
a5 [ 1 6 7 8 9 ]...etc

And I want to find those combinations in another file and highlight
it when it occurs.

the other file is similar but a lot bigger.

 

[vikesh]

You can use vlookup command. If u don't know how to use it then u ca
get help from"Paste function" command from Insert menu function. An
further help required, then mail me at (e-mail address removed)

Bye for now,

Vikesh

find or vlookup or dlookup?
I have a list like this on a worksheet:
( each set of 5 numbers in a cell. example:
a1 [ 1 2 3 4 5 ]
a2 [ 1 3 4 5 6 ]
a3 [ 1 4 5 6 7 ]
a4 [ 1 4 5 6 7 ]
a5 [ 1 6 7 8 9 ]...etc

And I want to find those combinations in another file and highlight
it when it occurs.

the other file is similar but a lot bigger

 

[Dave Peterson]

Chip Pearson has a bunch of techniques for working with duplicates at:
http://www.cpearson.com/excel/duplicat.htm

(as long as those two lists "look" the same.)

I have a list like this on a worksheet:
( each set of 5 numbers in a cell. example:
a1 [ 1 2 3 4 5 ]
a2 [ 1 3 4 5 6 ]
a3 [ 1 4 5 6 7 ]
a4 [ 1 4 5 6 7 ]
a5 [ 1 6 7 8 9 ]...etc

And I want to find those combinations in another file and highlight
it when it occurs.

the other file is similar but a lot bigger.