Inconsistent values returned from a Vlookup

Codfadder

New Member
Joined
Aug 23, 2013
Messages
1
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 2Actual LocationWorksheet 1Starting withoutWorksheet 1Vlookup Returned
Sales ItemLocationSales ItemLocationSales ItemLocation
85615993AG24B18561599385615993AG24B1
85615993AU16C18561599385615993AG24B1
85615993AO19B38561599385615993AG24B1
85615993AM17B38561599385615993AG24B1
85615993AM17A28561599385615993AG24B1
85615993AM12A18561599385615993AG24B1
85615993AL10B18561599385615993AG24B1
85615993AK16C18561599385615993AG24B1

<tbody>
</tbody>

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

mumps

Well-known Member
Joined
Apr 11, 2012
Messages
9,596
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.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,109,518
Messages
5,529,312
Members
409,862
Latest member
lbisacca
Top