Excel formula for day month year and amount

[Shan54321]

Hi ,

I have an excel sheet which need to extract data from multiple tab . Now my issue is i am unable to extract dd-mm-yyyy in master sheet with amount .

I need the data from "Sales register Tab" dd-mm-yyyyy format in master sheet column i5 and in i13 and the amount .

This data should change according to drop down list . Can any one help for me.???

[jason.b75]

Try this in I5, Array confirmed with Ctrl Shift Enter

=IFERROR(SMALL(IF(INDEX('Sales Register'!$AE$5:$BW$146,MATCH($B5,'Sales Register'!$I$5:$I$146,0),0),'Sales Register'!$AE$4:$BW$4),COLUMNS($I5:I5)),"")

and this in I6

=IF(I5="","",INDEX('Sales Register'!$AE$5:$BW$146,MATCH($B5,'Sales Register'!$I$5:$I$146,0),MATCH(I5,'Sales Register'!$AE$4:$BW$4,0)))

Drag both right to fill the table.

Use the same formulas for the second part, changing the ranges as needed.

[Shan54321]

Thanks a lot .I really helped me .