Multiple Search from 4 different criterias

[Coachmannyz8]

My formula is currently looking at 2 criterias; however, I need to add 2 more criterias to complete my search.

How can I modify or simply my formula? i tried different combinations and none seem to work.

My formula now;

=IF(ISERROR(INDEX('CPI Data 306 Detail Rpt'!A3:AC5460,SMALL(IF('CPI Data 306 Detail Rpt'!A3:A54560=O3,ROW('CPI Data 306 Detail Rpt'!A3:A5460)),ROW(1:1)),17)),"",INDEX('CPI Data 306 Detail Rpt'!A3:AC5460,SMALL(IF('CPI Data 306 Detail Rpt'!H3:H5460=M5,ROW('CPI Data 306 Detail Rpt'!A3:AC5460)),ROW(1:1)),8))

 

[jim may]

With Countifs() you can use well over 4 criteria using the parameters countifs(range1, criteria1, range2, criteria2, range3, criteria3, range4, criteria4)

 

[Coachmannyz8]

Thanks for the post Jim,
How can I end the formula on a count if to give me a zero if no data is found?