excel - Array formula with does not equal condition

Question

Essentially, I want to omit location(Y) from the result of the below array formula.

I'm using the array formula to find the Nth closest location to a postcode(X) - in this case the 1st closest. However, postcode(x) is chosen via another location(Y).

{(INDEX(PROXIMITY!$B$2:$B$14199,SMALL(IF(DASHBOARD!$C$22=PROXIMITY!$A$2:$A$14199,ROW(PROXIMITY!$A$2:$A$14199)-ROW(PROXIMITY!$A$2)+1),1))}

Cell C22 - is the postcode location
A2 - A14199 : list of Postcodes
B2 - B14199 : list of locations

UPDATE: Have solved this now. Am using the below formula. It was a lot simpler than I first thought (added the IF function), and probably was a little confusing with my explanation.

={IFERROR(INDEX(PROXIMITY!$B$2:$B$14199,SMALL(IF(DASHBOARD!$G$5<>PROXIMITY!$B$2:$B$14199,IF(DASHBOARD!$C$22=PROXIMITY!$A$2:$A$14199,ROW(PROXIMITY!$A$2:$A$14199)-ROW(PROXIMITY!$A$2)+1)),1)),"No repairers cover this postcode")}

question from:https://stackoverflow.com/questions/65844037/array-formula-with-does-not-equal-condition

Answer 1

Waitting for answers