Match & return data across multiple sheets, multiple criteria

**mrsproctor** · 02-18-2015, 05:24 PM

I am using this spreadsheet to track customer payments and send invoices. I have a master sheet named "Invoice". I enter customer payments on their separate sheets. I would like to use the master invoice sheet to choose a customer name and have their loan/payment information populate, rather than creating a new invoice for every customer.

I don't know how to return data based on multiple criteria in multiple sheets. I've attached my spreadsheet and added notes on the pages to better explain?

Please help!

**FDibbins** · 02-18-2015, 05:36 PM

1st of all, I think you are doing this all backwards. You should have 1 sheet where you enter ALL data 1 row per entry, so that you build up a data base.

Once you have your database formatted, you can then start building summary/analysis sheets.

**skywriter** · 02-18-2015, 06:01 PM

Here's a code solution. What this does is since it appears you are using the last name of your clients as sheet names, it extracts their last name from the drop down list and changes the formula in the cell where you want to see the dollar amount.

Good Luck!!!