### [Solved] Plz translate Excel formula to OpenOffice

Posted:

**Mon Jul 15, 2019 4:01 am**Hi

Am trying to solve my case in Oppenoffice so I found a the perfect exemple but its for excel...I tried the formula in Oppenoffice did not work...:

Formula 2. Vlookup multiple matches and return results in a row at link below

https://www.ablebits.com/office-addins- ... ues-excel/

=IFERROR(INDEX($B$3:$B$13, SMALL(IF($D3=$A$3:$A$13, ROW($B$3:$B$13)-2,""), COLUMN()-4)),"")

Could someone kindly please translate this excel formula for openoffice?

Many thanks

Am trying to solve my case in Oppenoffice so I found a the perfect exemple but its for excel...I tried the formula in Oppenoffice did not work...:

Formula 2. Vlookup multiple matches and return results in a row at link below

https://www.ablebits.com/office-addins- ... ues-excel/

=IFERROR(INDEX($B$3:$B$13, SMALL(IF($D3=$A$3:$A$13, ROW($B$3:$B$13)-2,""), COLUMN()-4)),"")

Could someone kindly please translate this excel formula for openoffice?

Many thanks