Forum Discussion
Searching multiple fields using MATCH (with OFFSET) and INDEX functions
I am building a spreadsheet that catalogs books for the teachers in my school. To make it easier for teachers to search by Book Level, Genre, Text Structure, or Text Feature, I made a second sheet i...
Thanks so much. I used your IFERROR suggestion and it cleaned things up greatly.
How can I change the formulas in columns G and H to search for "contains" a text feature in column H instead of "exact match"?
For example, if I want a list of all books containing "Speech Bubbles" and not just the books that ONLY contain Speech Bubbles. Thanks again for your help. Much appreciated.
Disregard. I got it to work using wildcards. Thanks again.