Chip Pearson has some techniques to determine differences between lists:
http://www.cpearson.com/excel/duplicat.htm

An once you get that skinnied down list, if you still want to use =vlookup(),
you can see some nice instructions at Debra Dalgleish's site. And depending on
how the data is laid out, you may want to use =index(match()).

Debra Dalgleish's has some notes you may like:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))



mkangas wrote:

I work in an inventory dep't and daily receive a report with part
numbers and other information. Part of my job is to research these
part numbers in an SAP program. Anyway, every day the list will grow
with some "new" numbers, some repeated numbers and some numbers that
have dropped off the list. Obviously I don't want to have to research
numbers I have already done, so I am looking for a way for Excel to
give me a list of "unique" part numbers as it looks at more than one
spreadsheet or more than one column of numbers. I think it is a
Vlookup that I want to do but I just do not know how to run it. I have
tried and tried, but no luck. Can someone please help me write the
formula and then I can save it and run it day to day? I would truly
appreciate it. There is someone that works here that knows how to do
this very handily but she is just TOO busy to be bothered. Vlookup
makes NO sense to me whatsoever, but I am sure it is what I need to
use. Oh, a bit more info: the one column is only like 80 lines, then
the one I want to compare it to is like 160 lines or so.. it grows and
changes every day though. Can someone please help me! YOu can email
me direct at: as well. Thanks so very
much.......

--
mkangas
------------------------------------------------------------------------
mkangas's Profile: http://www.excelforum.com/member.php...o&userid=28625
View this thread: http://www.excelforum.com/showthread...hreadid=482888

--

Dave Peterson