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
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
is there a way to adapt and be able to return both lines (or more)
hope that makes more sense
Thanks
Bookmarks