![]() I looked up on various forums and I realized that VLOOKUP command only allows me to search on Name OR Country would give me the common entries of Names/Countries respectively but not Item No.s. If there is no match, then I would like Excel to tell me that this is a new entry. Now, I want Excel to compare the names AND countries of both data and provide the common Item No. In the second list, there are again Item No.s, Name and Country but some item numbers haven't been filled ( since they are new and have not yet been sorted). Let's assume that the item numbers have been classified based on some code words. The third argument is the column in that range of cells that contains the value that you. The second argument is the range of cells, C2-:E7, in which to search for the value you want to find. This argument can be a cell reference, or a fixed value such as 'smith' or 21,000. ![]() ![]() List with common serial No.s based on common names from both listsĪs can be seen in this attachment, I have an old list with Item No., Name and Country. For VLOOKUP, this first argument is the value that you want to find. Sorry, if this has not been well explained, but maybe the following illustration helps Old List Later on, I would like to create a new list with common entries from both old and new list and add all the new entries below the common ones ( if possible, else I will do that manually later on but I would like Excel to tell me that this is a new entry). I wish to compare the new list( comparing name and country together) with an old list, since the new list has a few additional entries. I basically have two sets of data- an old list and a new list. Please give your valuable pointers if possible, so that I can try to find the solution. I have been breaking my head with this problem since morning and I haven't found a solution.
0 Comments
Leave a Reply. |