I'm going to use the following Table below as an example. What kind of Index formula could I use that could look through the table and find instances of "Dog" and color "Red" and bring back the other values in the row?
[table="width: 500, class: grid"]
[tr]
[td]Animal[/td]
[td]Name[/td]
[td]Color[/td]
[td]Size[/td]
[td]State[/td]
[/tr]
[tr]
[td]Duck[/td]
[td]Daffy[/td]
[td]Blue[/td]
[td]2X[/td]
[td]Michigan[/td]
[/tr]
[tr]
[td]Mouse[/td]
[td]Mickey[/td]
[td]Red[/td]
[td]3X[/td]
[td]Ohio[/td]
[/tr]
[tr]
[td]Mouse[/td]
[td]Minnie[/td]
[td]Green[/td]
[td]3X[/td]
[td]Michigan[/td]
[/tr]
[tr]
[td]Dog[/td]
[td]Goofy[/td]
[td]Red[/td]
[td]2X[/td]
[td]Ohio[/td]
[/tr]
[tr]
[td]Dog[/td]
[td]Porky[/td]
[td]Green[/td]
[td]1X[/td]
[td]Georgia[/td]
[/tr]
[tr]
[td]Bunny[/td]
[td]Bugs[/td]
[td]Red[/td]
[td]4X[/td]
[td]Florida[/td]
[/tr]
[tr]
[td]Dog[/td]
[td]Pluto[/td]
[td]Red[/td]
[td]3X[/td]
[td]Texas[/td]
[/tr]
[/table]
[table="width: 500, class: grid"]
[tr]
[td]Animal[/td]
[td]Name[/td]
[td]Color[/td]
[td]Size[/td]
[td]State[/td]
[/tr]
[tr]
[td]Duck[/td]
[td]Daffy[/td]
[td]Blue[/td]
[td]2X[/td]
[td]Michigan[/td]
[/tr]
[tr]
[td]Mouse[/td]
[td]Mickey[/td]
[td]Red[/td]
[td]3X[/td]
[td]Ohio[/td]
[/tr]
[tr]
[td]Mouse[/td]
[td]Minnie[/td]
[td]Green[/td]
[td]3X[/td]
[td]Michigan[/td]
[/tr]
[tr]
[td]Dog[/td]
[td]Goofy[/td]
[td]Red[/td]
[td]2X[/td]
[td]Ohio[/td]
[/tr]
[tr]
[td]Dog[/td]
[td]Porky[/td]
[td]Green[/td]
[td]1X[/td]
[td]Georgia[/td]
[/tr]
[tr]
[td]Bunny[/td]
[td]Bugs[/td]
[td]Red[/td]
[td]4X[/td]
[td]Florida[/td]
[/tr]
[tr]
[td]Dog[/td]
[td]Pluto[/td]
[td]Red[/td]
[td]3X[/td]
[td]Texas[/td]
[/tr]
[/table]