I have this code and its working great but only on the first line. I need on B4 the last part to be![]()
Range("B4:B8").FormulaArray = "=INDEX(Entered!A:A,SMALL(IF(ISNUMBER((SEARCH($A$2,Entered!$A$2:$A$6002))),ROW(Entered!$B$2:$B$6002)),ROW(Entered!$A1)))"
and![]()
ROW(Entered!$A1)))
on B5 and so forth. Is there a way to get it to do this?![]()
ROW(Entered!$A2)))
Bookmarks