Hello, im new in this community. I search all around the posts of this forum trying to search my question, but i couldnt. Here is what I need to do:
In the image, we can see the first lookup (which content is agencia4), have 2 results. In the right LOOKUP, I want that the formula give me back all the results as posible, Using the 2 variables (Date and Agencia)(which now content is Agencia4 & 13-7)
Here is the formula I've used to make the first LOOKUP:
=ArrayFormula(IF(ISERROR(INDEX($A$1:$C$8;SMALL(IF($B$1:$B$8=$F$1;ROW($B$1:$B$8));ROW(1:1));2));"";INDEX($B$1:$C$8;SMALL(IF($B$1:$B$8=$F$1;ROW($B$1:$B$8));ROW(1:1));2)))
This formula is put in cell F2, and copied cell by cell in all column F.
I'd apreciate a quick and correct answer, its very important for my work!
Many Thanks,
Ezequiel
(Sorry if I've wrote anything wrong, my first language is spanish!)

In the image, we can see the first lookup (which content is agencia4), have 2 results. In the right LOOKUP, I want that the formula give me back all the results as posible, Using the 2 variables (Date and Agencia)(which now content is Agencia4 & 13-7)
Here is the formula I've used to make the first LOOKUP:
=ArrayFormula(IF(ISERROR(INDEX($A$1:$C$8;SMALL(IF($B$1:$B$8=$F$1;ROW($B$1:$B$8));ROW(1:1));2));"";INDEX($B$1:$C$8;SMALL(IF($B$1:$B$8=$F$1;ROW($B$1:$B$8));ROW(1:1));2)))
This formula is put in cell F2, and copied cell by cell in all column F.
I'd apreciate a quick and correct answer, its very important for my work!
Many Thanks,
Ezequiel
(Sorry if I've wrote anything wrong, my first language is spanish!)