Hello
this is my array formula which works - after a fashion! The formula shows a number of rows based on key pieces of data in B2 or B3 - however, I need the formula to only show information that has B2 AND B3 in it. I have tried AND and * in a number of places in this formula but no luck - any advice would be greatly received.
Also, do you know if I can extend this formula to look at 3 pieces of information?
Thank you.
=IF(ISERROR(INDEX('[Service Data.xlsm]DATA'!$A$1:$S$5000, SMALL(IF('[Service Data.xlsm]DATA'!$A$1:$S$5000=$B$2, ROW('[Service Data.xlsm]DATA'!$A$1:$S$5000)),ROW(1:1)),12)),"", INDEX('[Service Data.xlsm]DATA'!$A$1:$S$5000,SMALL(IF('[Service Data.xlsm]DATA'!$A$1:$S$5000=$B$3,ROW('[Service Data.xlsm]DATA'!$A$1:$S$5000)),ROW(1:1)),12))