Vlookup Help

[molivi311]

I am trying to use vlookup to see what items I have missing from a master spreadsheet. The problem is that the same items are listed twice and it will always return the 1st one See below for example and let me know if there is a good formula to use to solve this.
Master
m# desc q row#
71440491 PIN PULLER 1 1
71440491 PIN PULLER 1 54

Results

m# row#
71440491 1
71440491 1

As you can see it just pulls the 1st one so I am not able to get a true picture of what is going on. Can anyone assist with this?

[Rem0ram]

attach a sample file.

[molivi311]

Attached is a sample of the spreadsheet. What I am wanting is to only have the row# from the master column used once.

Please help if you can.

Thanks,

[Rem0ram]

chk this...

[molivi311]

Thanks for looking at it but that was not exactly what I was looking for. Let me explain what I am trying to do more clearly. I am receiving in some parts (they are in the master data sheet) and I want the data sheet to cross reference the master and tell me what I need to still receive in. On the data sheet I would like for it to say yes you have rec'd this and it is in rowx or no you still need to receive it in. Vlookup my not be the right formula to use and I am open to anything. I just do this pretty frequently and have been doing it manually and believe if i knew how to do this with a formula it would be of tremendous help.

Thank you,

[Rem0ram]

chk this....

[molivi311]

Sorry to be difficult but on the attached spreadsheet is there a way to not have duplicate values in the data sheet row# field. If 1 has already been used will it then select #54 and so forth. Essentially have no duplicate values from the formula. I have read that index match is better than vlookup. would this allow this or any other formula. Do you understand what I am trying to accomplish?Attachment 345452