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...
C96 and C100 contain "Fable " (with a space after the word).
If you remove that space, it'll work.
I'd change the formulas in C5 and D5 to
=IFERROR(MATCH($D$2,OFFSET('Browse Books'!$C$1,C4,,1000),0)+C4,"")
and
=IFERROR(INDEX('Browse Books'!$A$1:$A$1102,C5),"")
and fill down.
Similar for the other columns.
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.
