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?
[td]Animal[/td]
[td]Name[/td]
[td]Color[/td]
[td]Size[/td]
[td]State[/td]
Duck | Daffy | Blue | 2X | Michigan |
Mouse | Mickey | Red | 3X | Ohio |
Mouse | Minnie | Green | 3X | Michigan |
Dog | Goofy | Red | 2X | Ohio |
Dog | Porky | Green | 1X | Georgia |
Bunny | Bugs | Red | 4X | Florida |
Dog | Pluto | Red | 3X | Texas |
[td]Name[/td]
[td]Color[/td]
[td]Size[/td]
[td]State[/td]