Inventory Sheet Evaluating - Locations in Multi Select Column

Allison Huerta

On my inventory sheet I have a list of items in rows. For each row-item I have a column with a multiple-select to identify how many locations have that item.

On a separate sheet, I'd like to be able to type a location and populate all the rows of inventory items that live at that location.

Any advice on which formula to use to accomplish this function?

Thanks!

Paul Newcome

I personally would suggest a report that looks at the location column and pulls whatever rows contain that particular location.

Paul Newcome

I personally would suggest a report that looks at the location column and pulls whatever rows contain that particular location.