Hi all,
I am using the below formula: -
=IFERROR(INDEX('sheet1'!$D$1:$D$3000,SMALL(IF((ISNUMBER((SEARCH($B$60,'sheet1'!$AH$1:$AH$3000))))*(ISNUMBER((SEARCH($C$55,'sheet1'!$AH$1:$AH$3000))))*(ISNUMBER((SEARCH($C$56,'sheet1'!$AH$1:$AH$3000)))),ROW('sheet1'!$D$1:$D$3000),""),ROWS('sheet2'!$B$62:$B62))),"")
The problem that I have it with the third condition (in bold and italics). So this condition could be a number of things selected from a dynamic list and for the majority of the time it is working. However, there are two values that could be selected in this cell that are very similar apart, for example: -
Test Sub 1
Sub 1
When either of the above is selected in cell C56 it lists all values from column D that holds either of the above two values in column AH (rather than separating them - if that makes sense).
Is there an amendment I can make to the formula that it needs to search for that specific text, that could be held anywhere within the cell?
thanks for the help in advance.
Bookmarks