find or vlookup or dlookup?

E

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.
 
V

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 [email protected]

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
 
D

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.)

eagerowl < said:
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.
Click to expand...
 
Top