Inconsistent values returned from a Vlookup

Codfadder

New Member
Joined
Aug 23, 2013
Messages
5
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>
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
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:
Upvote 0

Forum statistics

Threads
1,203,327
Messages
6,054,751
Members
444,748
Latest member
knowak87

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top