I'd like to add one more criteria in the formula below. The pivot where the formula gets its data from has a third column, and i want it to only show results with a "N" in column D. (Sheet 'Data Units') Right now it shows just the first results it can find in the validation listbox that I applied in B4. How do I add it to the formula below? Iv shown it very easily in the attached document. I tried Index Match but no avail.

=OFFSET(Pivot!$B$1, MATCH($A2, Pivot!$A:$A, 0)-1, , $B2, )

f.xlsm