Two values in one cell

Hello Naomi, 

In the attached file, I added Overdue Items and Overdue Days in Columns H and I, respectively. The formulas under Column H, starting in H4, return the list of the Overdue Items, which is a concatenation of the Membership Number, Library Name, and Item, through this formula: 

=IF(ROWS(A$4:A4)>COUNTIF(F$4:F$28,">0"),"",LOOKUP(PI(),
1/(F$4:F$28*(COUNTIF(H$3:H3,D$4:D$28&" "&B$4:B$28&" "&C$4:C$28)=0)=MAX(INDEX(
F$4:F$28*(COUNTIF(H$3:H3,D$4:D$28&" "&B$4:B$28&" "&C$4:C$28)=0),0))),
D$4:D$28&" "&B$4:B$28&" "&C$4:C$28))

Meanwhile, the formulas under Column I, starting in I4, return the Overdue Days in Descending Order, through this formula: 

=IF(H4="","",
LOOKUP(PI(),1/(D$4:D$28&" "&B$4:B$28&" "&C$4:C$28=H4),
F$4:F$28))

I know Detlef Lewin prefers the sexy PI() over the standard lookup_value argument of 2. I will make him smile by conceding to his preference.

Cheers!

Twifoo