aisle

  1. I

    Value VLOOKUP is searching for is negative - returns #N/A

    Team, Trying to keep this example simple. I have a pivot table: <tbody> A B C 1 Aisle # Locations Units 2 001 229 1569 3 002 1 -12 4 003 12 214 </tbody> I am trying to combine information in a spreadsheet from three pivot tables using the VLOOKUP. However, when I try to display the...
  2. T

    How to sort by multiple variables in a single title

    Hi, in my job, I need to sort by multiple variables in the same piece of text. The text signifies the location of an item in the building. The titels go like this tsDMG1A002B, in which, the "tsDMG" is the type of bin(pretty unimportant), "1A" is the floor(variable 1) and "002" is the number of...
  3. O

    Idea's Needed

    <tbody> Bay ID Item Number Quantity A1 111 20 A2 222 100 A3 222 100 A4 333 50 A5 222 100 </tbody> Hi Guys, I have a problem where I have been asked to map out a warehouse in Excel and the operator wants to be able to pull out all the locations of one particular...

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