Finding empty locations VLOOKUP?

[esoto56]

I want to compare my current locations (change daily) to my set locations in the system.

Let’s say I have locations 1-100, this is a constant (all available systematic locations).
Out of those 100, 90 can physically hold inventory. The other 10 are in the system as locations but cannot hold physical inventory for one reason or another, I can figure this out on my own.
Out of those 90, 80 physically have inventory.
I want to be able to find the 10 “empties” that don’t have inventory.

Our warehouse is fluid so most of the locations are taken but some empty out throughout the day.

The current practice to find empty locations is to walk our 760,000 square foot warehouse every morning. This can take up to 1-1.5 hours.

I can run a report that shows me all of the locations with inventory but not the ones that do not have inventory.

It’s not as easy as just using the one that aren’t in the report, like I stated above some locations show as available but cannot hold physical inventory for one reason or another. Also there are location that I would like to add note to when and if they pop up as being “available”. I have a spreadsheet that was used for a different warehouse function but it pop everything up that is entered, I only want the ones that are not duplicates? If that makes sense lol.



Thank you for your help

[modytrane]

Without a sample file and expected results [describe your logic], it's impossible to help you.

[dflak]

I want to compare my current locations (change daily) to my set locations in the system.
I can run a report that shows me all of the locations with inventory but not the ones that do not have inventory.

Get this list and compare it with a list of all the locations using =ISNUMBER(Match(Location on report, Table_All_Locations,0)) the False results are the empty locations.

[FDibbins]

Another way might be to use a filter and filter on the "0" or blank entries?

If you need help with this, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.