Need help with V Lookup

M

mkangas

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

Don Guillett

There is someone that works here that knows how to do
this very handily but she is just TOO busy to be bothered
Click to expand...

Perhaps you should speak to their boss or tell the boss to hire one of us
 
M

mkangas

This person showed me how to do it twice previously (the first time I
did not take notes), but the 2nd time I did and I was shown a Vlookup
but was using a different report/spreadsheet so not all the principals
are the same. I think it is a case of "you should be able to learn
this immediately and the fact that you can't doesn't warrant me showing
you again and being bothered again". Sorry, I don't mean to offend
anyone, just looking to get some help so I can do a better and more
thorough job.
 
D

Dave Peterson

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()))
 
Top