Creating Receipts Based On List...

[girt0n]

I have a document with two or three sheets. On of the sheets has donators address and other specific information. Second sheet is where I enter the check data (Amount, Check Number, Date, notes...), Third screen I have created a page that will let you select from a list of uses from sheet 1 and then populate each donation below in a list as a yearly receipt to print off or at least know an individual or groups yearly giving at any time that year. I have tried to use VLOOKUP to pull data from sheet 2 but VLOOKUP will only give me the first entry that any specific name gave. Any idea how to pull every individual check from one sheet and have it add into a list on a new sheet, almost like filtering and sorting?

[dilipandey]

Hi girt0n,

I guess you are looking for multiple results for a single donator.. Yes, this can be done using array combination of Index/Match/Row/If functions, suggest you to upload a sample workbook with dummy data so that I can show you the formula. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>