Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

finding new item in list

  Asked By: Brooklyn    Date: Sep 10    Category: MS Office    Views: 857
  

I have list of items with there prices wchich I have imported from the
companies site.I have to use it in my system where i have used vlookup
function to get prices from imported list everyday.but if there are
any new item added to list then first i have to find for new item
added then again it has to be add in my list then it will take
price,instead of doing all this do we have any function from which i
can compare new list with old list and if any new item will be there
then it will give list of new items added?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Rickey Scott     Answered On: Sep 10

Seeing you are already familiar with VLookUp, why not just use that. Put a
simple VLookUp against each item  in your new list, to look itself up in the
old list. If it's not there, you'll get a #N/A. If you get the new VLookUp
to return the price, you'll also be able to compare  the new and old prices.

(You can of course create just one VLookUp, then copy it down for all the
items in the new list.)

The only thing this won't find  is items  that have been removed from the new
list.

But, why do you have to add  individual new items to the old list? Why not
just replace the old list  entirely with the new list?

 
Didn't find what you were looking for? Find more on finding new item in list Or get search suggestion and latest updates.




Tagged: