Need help with V Lookup
 

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

Need help with V Lookup
 

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

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

--
Don Guillett
SalesAid Software

"mkangas" wrote in
message ...

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

Need help with V Lookup
 

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.


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

Need help with V Lookup
 

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