Vlookup based on value that appears in a column

[tkoziol]

Hello Everyone, I thought this one would be easy but I'm stumped. I'm trying to view and compare the inventory at multiple warehouses. The issue I'm having is that the warehouse location names are all in the same column.

Does anyone know how to populate the results table in the attached file?

[bebo021999]

C5:

Please Login or Register  to view this content.