Forum Discussion
looking to add a search function
I am making a recipe database and I want to be able to search all recipes by ingredient. It would be a cell on page 1 that references several cells from several pages and delivers a list of recipe names. Does anyone know if this can be done and if so how?
example: Page 1 is the home page, the following pages are each separate recipes. I want to search for all recipes that use broccoli, so I type in the word "broccoli" or choose from a drop-down menu of all ingredients the word "broccoli" and it displays a list of all the recipes in the database which contain the ingredient "broccoli"
2 Replies
Hazel,
the most simple way would be the Find feature:
I know you can use the find function to search the whole document, instance by instance, but i'd like to bring up a list of recipes instead. I know this might be complicated but it would be way more helpful.
