Extract row for specific cells with Criteria's

Hello Friends

In the Column B for the `ABC dmkijtfsh' and if the word `Faco' is not there then need to extract the row for specific cells (Column H, K, AA & AT)

In attached excel refer the required result in Sheet 2 Light yellow cells, Sheet 3 shows the after filtered view for better understanding.

thanks in advance

Sekar

I've looked at your workbook. Is it the filtered list you are trying to produce? Are you still using Excel 2010?

Yes, filtered rows (as shown in Sheet 3) with selected columns cells need to be plot by formula. Still using MS Excel 2010.

And so, back to the question...

In A2, copied across and down:

=IFERROR(INDEX(Sheet1!A:A,AGGREGATE(15,6,ROW(Sheet1!$B$4:$B$87)/((Sheet1!$B$4:$B$87="ABC dmkijtfsh")*ISERROR(SEARCH("Fako",Sheet1!$H$4:$H$87))),ROWS($1:1))),"")

Hello Glenn

Thank you

Amazing, I except i need array formula, but this is done without array formula,

This will save my lot of work.

Thanks again

Sekar