So, I have a Google sheet named "Product Data". In this sheet, I made several columns to define which product is available on which outlets.
For example: Milk, it's available in outlet 1 & 2, but not in outlet 3.
So I have several rows, where row B = product name, row H = availability in outlet 1, row I = availability in outlet 2, row J = availability in outlet 3.
In row H-J, I only fill the cells with letter "v" (because it's similar to checklist mark) if the product is available in certain outlet. If it's not available, then I let it blank.
Then, I have another Google sheet named "Outlet 1 Product", and I want to retrieve the product names from "Product Data" worksheet, but based on row H, if it's filled with "v", then the certain product will show up in row A.
I hereby attach the links that go to the mentioned Google Sheets:
Product Data Sample: http://bit.ly/2z6MylP
Outlet 1 Product Sample: http://bit.ly/2HchwgX
Any help would really appreciated. Thank you in advance.
Bookmarks