Search and return data = please help me brothers

[kprabhupaul]

I have 3 sheets file.

1st sheet about purchases
2nd sheet about sales
3rd sheet about day book

i will enter purchase bills by datewise in purchases sheet and enter sale bills by datewise in sales

now i want result in day book sheet

if i input date in day book sheet, it should return all the purchase and sales transactions one by one as output.

Please find the photo and file attachments.

thank you very much in advance

[samba_ravi]

A3

Please Login or Register  to view this content.

Try this and copy and paste across

[kprabhupaul]

thanks for kind reply,

if i paste above formula in daybook!a3,

i'm getting all the dates in purchases and sales. but how to get remaining coloumns like bill no, debit and credit.

thank you very much brother.

[kprabhupaul]

Dear Brother,

Please modify my document with formulas and reply me brother.


thank you.

[samba_ravi]

see the attached file

[kprabhupaul]

Dear All,

I will enter Data by Datewise in different sheets like Purchase entries in Purchases sheet, Sale entries in Sales sheet, Receipt entries in Receipts Sheet and so on ..

Now the required result/data is

if I input particular date,

It should return all the transactions on that date one by one with Date, Ref/Bill No, Description, Debit and Credit values.

Please find the photo and file attachment for named ranges and for better idea.

thank you very much in advance