Inconsistent values returned from a Vlookup

[Codfadder]

I have a file that contains repeated line item records for sales orders. This file has two worksheets. The first worksheet contains the line items of the sales items. The second worksheet also shows the same line items but this one shows the location those line items came from. I want to look up the line item in sheet two and return the location in sheet one. But when I use the vlookup it looks at the first line item location in sheet 2 location repeats the same location when I copy for the rest of the cells.

Worksheet 2 Actual Location Worksheet 1 Starting without Worksheet 1 Vlookup Returned Sales Item Location Sales Item Location Sales Item Location 85615993 AG24B1 85615993 85615993 AG24B1 85615993 AU16C1 85615993 85615993 AG24B1 85615993 AO19B3 85615993 85615993 AG24B1 85615993 AM17B3 85615993 85615993 AG24B1 85615993 AM17A2 85615993 85615993 AG24B1 85615993 AM12A1 85615993 85615993 AG24B1 85615993 AL10B1 85615993 85615993 AG24B1 85615993 AK16C1 85615993 85615993 AG24B1 <tbody> </tbody>

<tbody>
</tbody>

 

[mumps]

Vlookup will always return the first matching value it finds. If the Sales Items are always in the same row on both sheets as shown in your screen shot, then a simple formula in Sheet1 under location will work: =Sheet2!B2 in cell B2 and copy down.