To Pull out data in excel – on the basis of conditions

[Shahmeer]

Hi, dear experts please help me to make a report on excel. I want to process payments based on Specific Date of Payment and in their demanding currency.
>>>>>>>There are more than one currencies and different payment dates.
>>>>>>>Many Customers are repeating (same customer but different dates & Currencies)
Data must be extracted / pull out in result sheet on two conditions:
1) Date of Payments; and
2) Currency
I want to have data in following columns to process payments by entering date on the date of payment:
1. Account Title
2. Account Number
3. Amount

=IF($A5=0," ",INDEX(Data!$B$4:$F$129,ROW()+4,CHOOSE(COLUMNS($B:B),1)))
Above formula is not working.

[JohnTopley]

In B5

=IF($A5=0," ",IFERROR(INDEX(Data!$C$4:$C$129,AGGREGATE(15,6,(ROW($A$4:$A$129)-ROW($A$4)+1)/(Data!$B$4:$B$129='Result Sheet'!$B$2),ROWS($1:1))),""))

You do not specify which currency (?) or are you expecting formatting of amount to reflect the currency (need VBA for this)

[Shahmeer]

Sorry Johan its not working in B5.

[JohnTopley]

??

See attached:

[Shahmeer]

Respective currency:

=IF($A5="USD",IFERROR(INDEX(Data!$C$4:$C$129,AGGREGATE(15,6,(ROW($A$4:$A$129)-ROW($A$4)+1)/(Data!$B$4:$B$129='Result Sheet'!$B$2),ROWS($1:1))),""),"")

[JohnTopley]

As you moved the date from B2 to C2, then change the formula accordingly

[Shahmeer]

Thanks you so much. So nice of you. God Bless you.