Thread: 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: kangasmaryl@johndeere.com as well. Thanks so very much.......

> 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
donaldb@281.com
"mkangas" <mkangas.1y556z_1131390901.8091@excelforum-nospam.com> wrote in
message news:mkangas.1y556z_1131390901.8091@excelforum-nospam.com...
>
> 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: kangasmaryl@johndeere.com 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
>

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.

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: kangasmaryl@johndeere.com 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