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>
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

mumps

Well-known Member
Joined
Apr 11, 2012
Messages
11,729
Office Version
  1. 2013
  2. 2010
Platform
  1. Windows
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:
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,628
Messages
5,838,447
Members
430,549
Latest member
jayjay2022

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
Top