I'm trying to create a separate worksheet that searches another worksheet.
On "Sheet 1" I have a list of local restaurants with the type of food, type of dining, etc. On "Sheet 2" I would like to be able to select the type of food and the type of dining and have it return all results that match the criteria.
Right now, I'm able to return one row matching one criteria using the INDEX() and MATCH() functions.
Is there a way to do a query or something in order to return these results?
Bookmarks