Hello,
I have to return a warehouse location from one column or the one next to it. Think in terms of "virtual" warehouses (the locations in the system):
You might have 2 virtual warehouses...A&B for the sake of simplicity.
Warehouse A might house product A, OR, it might be in Warehouse B...