As per lookup date, filter and return a payment details of the date!

[Mohammad Munawar]

Hi,

Required a formula help as based on data in a sheet Column A to D, required a payment list of any particular date entered in Cell number I2.

As per lookup date in Cell Number I2,values to be filter and return the details of payments (ID number, Categories, Amount) of the date and details of each mentioned headers G4:I4.

Sample sheet enclosed and example desired results also be there in the sheet.


Thanks,

[bebo021999]

It refer to row 100 (can be adjusted more rows)
In G5:

Please Login or Register  to view this content.

Copy to H5
In I5

Please Login or Register  to view this content.

Drga all down as far as needed

[Shareez Saleem]

Use this formula and paste it across down and right.

=IFERROR(INDEX(A$5:A$24,AGGREGATE(15,6,IF($I$2=$D$5:$D$24,ROW($A$5:$A$24)-ROW($A$5)+1),ROWS($G$4:G4))),"")

[Mohammad Munawar]

Many thanks to all for your support and provided solutions.