Forum Discussion
ocatrina
Apr 04, 2020Copper Contributor
Meet criteria in two columns on diff worksheet and populate the worksheet when user enters InvNum
Any help appreciated...Self Taught Excel Enthusiast... =IFERROR(INDEX(DataEntry!$F$2:$F$1000, IF(AND(DataEntry!$D$2:$D$1000=$A$1,DataEntry!$C$2:$C$1000="KomRip"),ROW(DataEntry!$F$2:$F$1000)-MIN(R...
- Apr 05, 2020OK..After all day, I have the answer.
=IFERROR(INDEX(DataEntry!$C$2:$F$1000, SMALL(IF(COUNTIF($A$1,DataEntry!$D$2:$D$1000)*COUNTIF($B$1,DataEntry!$C$2:$C$1000),ROW(DataEntry!$C$2:$F$1000)-MIN(ROW(DataEntry!$C$2:$F$1000))+1), ROWS($A$26:A26)),COLUMN(D1)),"")
Patrick2788
Apr 05, 2020Silver Contributor
=FILTER(DataEntry!F:F,((DataEntry!C:C=$B$1)*(DataEntry!D:D=$A$1)))
ocatrina
Apr 05, 2020Copper Contributor
Patrick2788Thank you for your work! That worked on A26 of the ShipDetForm, but did not provide the rest of the POs for a particular invoice. ... and I don't know enough to adapt it to do that. Do you?
- Patrick2788Apr 05, 2020Silver Contributor
Which one is not working?
- ocatrinaApr 05, 2020Copper ContributorYour formula populates the first PO of the invoice over and over. It does not bring in the other purchase orders of the invoice as I drag down rows A26:A44. I love your formula for its simplicity if you could make that happen. 🙂
- ocatrinaApr 05, 2020Copper ContributorThe formula I got to work would populate each row, as I dragged the formula over them, dependent upon if there were more PO#s to be had for the invoice, then left the rows blank when there were no more to be moved onto the ShipDetForm.