i attached herwith the excel file
where in Sheet1 contain my main data
and in sheet2 i used forumulas
in sheet2
colum A3
i used below Arrary forumla
=IFERROR(INDEX(Sheet1!F$2:F$1000,SMALL(IF(Sheet1!$A$2:$A$1000=Sheet2!$A$1,ROW(Sheet1!$A$2:$A$1000)-ROW($A$2)+1,""),ROWS($A$2:A2))),"")
now
i want same formula but in GOOGLE SHEET
i dont know how to apply this on Google Sheet
please help me
same in google sheet1 and sheet2
Bookmarks