Hello, I've been a long time learner form this forum but decided to join in the conversation. I've been fighting with this workbook for days now and have it somewhat close on a few parts. Here's my details.
My Goal:
- reference main data sheet
- create list based on drop down selection
- check multiple rows in data sheet
- use index and match with multiple criteria from multiple columns
- I'd like to be able to use as many items or as few if possible
I've been having trouble because each user can have many "items" and our data is receive in this format. I've tried to work from similar examples but can't seem to get the multiple to work. I've attached a worksheet for example. In this sheet my formula broke for "1. item1 Only" when preparing to share but I do have a single item working with the formula in A1 of "1. item1 Only". If I'm leaving out helpful details please let me know.
Thanks in advance!
Morley
Bookmarks