Forum Discussion

ocatrina's avatar
ocatrina
Copper Contributor
Apr 04, 2020
Solved

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...
  • ocatrina's avatar
    ocatrina
    Apr 05, 2020
    OK..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)),"")

Resources