benwhite
New member
- Joined
- Mar 28, 2021
- Messages
- 3
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 365 - Build 2102
Good morning/afternoon all,
Absolute Excel novice here, you all came highly recommended.
I have a spreadsheet containing dishes produced for a catering operation. I would like to have a separate sheet with a search function that can print the name of the dish, and also the title of the location of the dish (Salads, Meat etc).
Some points:
I have attached my initial working copy, with my idea of how the Search Page could look. Again, absolute novice here so seeking some guru assistance.
Thank you all in advance and apologies if this thread is in the wrong area. Mods, please move if required.
Cheers!
Ben
Absolute Excel novice here, you all came highly recommended.
I have a spreadsheet containing dishes produced for a catering operation. I would like to have a separate sheet with a search function that can print the name of the dish, and also the title of the location of the dish (Salads, Meat etc).
Some points:
- I need to be able to add more dishes without amending the search formula used
- About 45 new data points to be added per day
- To be used across multiple devices, eg laptop, ipad (not sure if this is impactful)
- Easy to maintain
- There is only one column of data per sheet, only the name of the dish is listed
- If I search for 'corn', the search page will list all the dishes containing 'corn', as well as the title location, eg 'salads', 'hot sides' etc
I have attached my initial working copy, with my idea of how the Search Page could look. Again, absolute novice here so seeking some guru assistance.
Thank you all in advance and apologies if this thread is in the wrong area. Mods, please move if required.
Cheers!
Ben