Hi ExcelForum members,

I have a problem. I just thought having a sheet that the function is to search for transaction recorded in the summary journal sheet but i can't do such because my knowledge is limited to basic excel function.

In my worksheet, i have a summary journal of accounting entries. All accounting entries are there. I made a searching area where i could find my information needed. If I enter entry number on the cell provided for the search, all information match to the entry number will be shown on the table provided. If I enter the account title, all information match to the summary will be shown on table provided.

I made a sample of my work.

Please see attachment for a clearer view, sorting list from bunch of data.xlsx

Thanks in advance!

dondon