SORT(UNIQUE(IF((('Pur-Pay Recd Sheet'!$D$5:$D$2100=$I$7)*('Pur-Pay Recd Sheet'!$F$5:$F$2100>=$D$8)*(

[O_P_Heda]

SORT(UNIQUE(IF((('Pur-Pay Recd Sheet'!$D$5:$D$2100=$I$7)*('Pur-Pay Recd Sheet'!$F$5:$F$2100>=$D$8)*('Pur-Pay Recd Sheet'!$F$5:$F$2100<=$I$8)),CHOOSE({1,2,3,4,5,6,7,8,9},'Pur-Pay Recd Sheet'!$C$5:$C$2100,'Pur-Pay Recd Sheet'!$A$5:$A$2100,'Pur-Pay Recd Sheet'!$F$5:$F$2100,'Pur-Pay Recd Sheet'!$B$5:$B$2100,'Pur-Pay Recd Sheet'!$E$5:$E$2100,'Pur-Pay Recd Sheet'!$G$5:$G$2100,'Pur-Pay Recd Sheet'!$H$5:$H$2100,'Pur-Pay Recd Sheet'!$I$5:$I$2100,'Pur-Pay Recd Sheet'!$J$5:$J$2100))))  in this formula out of 108 cells of 9 columns, in 5 cells in 5th  column result is not proper showing error “VALUE!”  please help, on remote link system 

Why I should remove highlighted words , this is my sheet name

[#2]

@O_P_Heda 

If you mean formula

=SORT(
   UNIQUE(
      IF(
         ('Pur-Pay Recd Sheet'!$D$5:$D$2100=$I$7)*
         ('Pur-Pay Recd Sheet'!$F$5:$F$2100>=$D$8)*
         ('Pur-Pay Recd Sheet'!$F$5:$F$2100<=$I$8),
         CHOOSE({1,2,3,4,5,6,7,8,9},
            'Pur-Pay Recd Sheet'!$C$5:$C$2100,
            'Pur-Pay Recd Sheet'!$A$5:$A$2100,
            'Pur-Pay Recd Sheet'!$F$5:$F$2100,
            'Pur-Pay Recd Sheet'!$B$5:$B$2100,
            'Pur-Pay Recd Sheet'!$E$5:$E$2100,
            'Pur-Pay Recd Sheet'!$G$5:$G$2100,
            'Pur-Pay Recd Sheet'!$H$5:$H$2100,
            'Pur-Pay Recd Sheet'!$I$5:$I$2100,
            'Pur-Pay Recd Sheet'!$J$5:$J$2100
         )
      )
   )
)

it works correctly. I mean without errors, have no idea about expected results.