Hi All,
I have data with some of it have multiple/replicate info.
etc. 1 ref with 2 data to populate
before this i'm using this formula and seem working fine
=INDEX(all,SMALL(IF(COUNTIF($E$12,CIty_Formula)*COUNTIF($E$10,Type_Formula)*COUNTIF($E$8,FY_Formula),ROW(all)-MIN(ROW(all))+1),ROW(Data!G2)),COLUMN(Data!M2))
however for this data this formula is not functioning so i change to index match and missing some formula to make it work. Hope anyone could share me your experience
Thanks
Bookmarks