Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =IFERROR(INDEX(Sheet1!$B$1:$B$4,SMALL(IF(ISERROR(FIND("o",LOWER(Sheet1!$A$1:$A$4))),9999,ROW(Sheet1!$A$1:$A$4)),ROW())),"")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement