Multiple References in an Array Forumula

Hi All,

I am trying to modify this array formula to reference/match a second set of values. The formula as written now is matching the "Purchase Order Number" only, and I need to have the array match the "Purchase Order Number" and also the "Sold-to Party". I unfortunately, have no clue how to do this. Any help is appreciated.

This is the formula as currently written (the larger document is the "KB" tab and the smaller is the "KE" tab):

=INDEX(KE!$A$2:$B$35428,SMALL(IF(KE!$A$2:$A$35428=$D2,ROW(KE!$A$2:$A$35428)-1),COLUMNS($F2:F2)),2)

Thank you!

Welcome to the forum!

This should do what you ask for

=INDEX(KE!$B$2:$B$35428,SMALL(IF(KE!$A$2:$A$35428=$D2,IF(KE!$C$2:$C$35428=$A2,ROW(KE!$A$2:$A$35428)-1)),COLUMNS($F2:F2)))

This worked perfectly, thank you!