How to find value different than value existing in selected range?

[Yorlasty]

Hi all,

that's my first post here, so hello everyone!

I'm trying to find a way of ignoring results from vlookup if that result maching any of the values from selected range.

Example of source data:

                                                                 <table x:str="" style="border-collapse: collapse; width: 138pt;" border="0" cellpadding="0" cellspacing="0" width="184"><col style="width: 69pt;" width="92"> <col style="width: 69pt;" width="92"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 69pt;" height="17" width="92">        
<table x:str="" style="border-collapse: collapse; width: 138pt;" border="0" cellpadding="0" cellspacing="0" width="184"><col style="width: 69pt;" width="92"> <col style="width: 69pt;" width="92"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt; width: 69pt;" height="17" width="92">SKU</td> <td style="width: 69pt;" width="92">ID</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">BK093553</td> <td class="xl26" style="border-left: medium none;" x:num="140547106207">140547106207</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">BK093553</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="120720835584">120720835584</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">BK093553</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="120720835584">120720835584</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">BK093553</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="120741052463">120741052463</td> </tr> </tbody></table></td> <td class="xl25" style="border-left: medium none; width: 69pt;" x:num="140547106207" width="92">
</td> </tr> </tbody></table>

Question:

Now i have list of 3 items with same SKU (BK093553, BK093553, BK093553) but ID's are not assigned and I'm trying to find unique ID for all of them. How to do that? By using Vlookup I'll always receive first corresponding ID from the list.

If you need more explanation, don't hesitate to ask.

Regards,
Yorlasty

 

[moonfish]

I don't understand what you're trying to do here. You want to use a unique ID to do a vlookup on data so that you can give them a unique ID? I don't think vlookup is the solution for your problem.

You should try to organize your source data so that it contains a unique identifier, not one obtained by vlookup.

 

[Yorlasty]

Ok, I'll try to be more precise. In one file I have list of stock with ID assigned to every item.

In second file I have only list of stock.

How to assign unique ID from first list to items from second list knowing that SKU (item number) is the only thing these two files have in common - so it's my only point of reference for any "lookups".

Thanks

 

[moonfish]

I would recommend working from the file that has the unique identifiers. Bring all your other data there (by using lookup functions). Excel's vlookup doesn't allow for listing second or third matches, you'll probably be needing VBA to accomplish that.

Once everything is in the same excel sheet, you can create a pivot table to group your data by SKU.