in a1:a47 i put manually numbers fro 1 to 36 ,so how we can have an array formula which say:if the last number from below at a1:a47 is 9 (for example) ,extract some specific numbers which are in a range b1:b18) for example.i was thinking something like that:IF(INDEXA1:A47,MATCH(99^99,A1:A47,1))=9,INDEX(B1:B18,ROWS($1:1), i dont know how.
Bookmarks