Hello,
I have a formula which equals to "CMB" and would like to also equals "AS-07", is this possible with the following formula:
=IFERROR(INDEX('List of Ex1-5'!$B$2:$B$150,AGGREGATE(15,6,(ROW('List of Ex1-5'!$B$2:$B$150)-ROW('List of Ex1-5'!$B$2)+1)/('List of Ex1-5'!$A$2:$A$150="CMB"),ROWS(A$1:A1))),"")
Thanks
Bookmarks