Comparison of two sheets within their unique values

[rubertpablo7]

I have been trying to find a way to compare bin locations and the part #s in those locations for a warehouse. Each part has its unique numbers and locations, and I was wondering if there is a way to have a unique formula that compares two sheets of those locations and the parts within them. For example, in the Excel sheet if W13A-09-1 shows in the first sheet, so when I scan into the second sheet, or manually type it, it should give me a code, 1,2,3, or True or False that is in the 1st sheet.

 

[KRice]

it should give me a code, 1,2,3, or True or False that is in the 1st sheet

What does this mean? I don’t see any of those terms in the 1st sheet.

 

[rubertpablo7]

Forgive me. I was trying to do an IF formula, to see if both columns of A and B are true in both sheets it would be true, or change it so it can code it as 1, as for our term in the warehouse, 1 means the part is in the correct bin location. That is what I meant for a True or False statement for both sheets.

 

[KRice]

Let me see if I understand correctly. You have two workhseets (what are their names?). One sheet contains a warehouse record of items, each item has a Part number (the Part column) and a location (the Bin column). Someone then separately scans each item and records the part number and bin location in a different worksheet. And you want to compare the two worksheets and record a "1" in the scan worksheet if the item scanned correspond to an item with the same part number and bin location on the other worksheet?

So there can be multiple items having the same part number and bin location, correct? And if that is the case, then there must be a one-to-one correspondence when matching between the two lists to prevent multiple items in the scanned list being matched against a single entry in the initial warehouse record?...is that correct?

 

[rubertpablo7]

Yes, that is correct. Each item scanned has a unique bin and they are in multiple locations, so I don't want the Worksheet to compare if we have the part overall, but if it's in their unique locations as we put in the 1st Worksheet. The 1st Worksheet can be called the WH Part to Bin Locations, and the 2nd Worksheet can be called Location Audit Tracker. Everything you said is spot on, on what I need, if it is possible it would be highly appreciated.

 

[KRice]

I’m still not clear on what each row represents. Let’s go back to this statement in my last post…”So there can be multiple items having the same part number and bin location, correct?”

Could you have 10 widgets, all part number 1A residing in bin 2? If that is plausible, would you expect 10 rows in WH showing p/n 1A and bin 2? And then you would you also expect the same number of rows (10) in the Location Audit Tracker sheet with the same p/n and bin?