Formula Returning one line only

[ExcelRoy]

Hi,

I have the following formula

=IFERROR(INDEX(Backorders!$G$2:$G$1000,MATCH(D10&F10,Backorders!$B$2:$B$1000&Backorders!$H$2:$H$1000,0)),"")

which returns the "Quantity" based on column B (Job No) and column H (Part Number)

This works great if there is only 1 in the list but if there is 2 it only returns the first entry and not the second

is there a way to adapt and be able to return both lines (or more)

Thanks

 

[ExcelRoy]

Having read my post I think a bit of clarity is needed

If I enter the first job number and part number my formula returns ok, but I then want to return the same part number on the same job (a 2nd entry) my formula only returns the same 1st entry

hope that makes more sense