Formulas to Return Multiple Matches

[Bart60]

Hi,

On the Lookup Invoice sheet there are cells with some data highlighted yellow (B20:E29). Does anyone know formulas to get this data from the Invoice Data sheet I14:L21 based on the Invoice Number in cell H3 on the Lookup Invoice sheet.

This number should match the Invoice Data sheet range B14:B21.

Thank you,
Bart

PS This is not a duplicate thread

[FlameRetired]

If I understand correctly try this in Invoice Data I14:L21

=IF('Lookup Invoice'!$H$3='Invoice Data'!$B14,'Lookup Invoice'!B20,"")

Then Custom Format the range 0;-0;;@ to get blanks for the blanks instead of 0s.

[Bart60]

Oh sorry I wanted the formulas for the Lookup Invoice sheet.

[CAABYYC]

B20=IFERROR(INDEX(Table14[CODE],SMALL(IF(Table14[INV]=$H$3,ROW(Table14[INV])-13,"/"),ROW(A1))),"") Control+Shift+enter, then copy to B29
C20=IF($B20="","",VLOOKUP($B20,Table14[[CODE]:[UOM]],COLUMN(B1),)) copy to right and down

[Bart60]

@CAABYYC that works perfectly thank you so much!