Multiple return formula

**Jesikaha** · 02-22-2009, 10:09 PM

I can not seem to figure out a formula to return multiple results from multiple worksheets, within one workbook. Example, if each worksheet represents one inservice class and each class has an individuals name, id and date on it. Each individual may be listed more than once on each worksheet, and may be on each worksheet. Is there a formula I can input on my 'invoice type' form to return every time their name is found. I can only get it to return the first time it finds their name and it will repeat this info on every line of my invoice. This is an example of one of the formulas I am using to find their information, currently I have to have it separated by worksheet, which I have to delete the line info if they did not attend inservice for that specific worksheet. =IF($C9,(VLOOKUP($C9,'BR-Sat'!$B$12:M$45,7,FALSE)),"")

**JBeaucaire** · 02-22-2009, 10:32 PM

There are some heavylifting formulas that "might" be able to do what you want, but your description is such that I think an on-demand macro might be the best solution for you.

For that to happen, you'll need to post up your workbook, or smaller version of it with enough information in it to fully present your need, including the INVOICE.

The VBA gurus will most likely be able to assist.

**Jesikaha** · 02-22-2009, 11:00 PM

Here is an example of a similar sheet uses the same format just for different things. The other is on my computer at work. Here I insert the number of the child on the invoice and it pulls all of their winnings for the rodeo that weekend. I currently have a line specifically dedicated for each worksheet b/c I can't figure out how to get it to find that child more than once through each worksheet.

**JBeaucaire** · 02-22-2009, 11:28 PM

You don't show what you're looking to happen on the invoice instead of what's there. Can you lay that out with a sample child or two?

**Jesikaha** · 02-23-2009, 12:00 AM

On the invoice if next to contestant # type 7074. This will pull up a child and all of the classes (LW Barrels-Saturday...), one for each worksheet. She competed in each class, but those with an NT she did not place in. Which is fine b/c she actually competed in each event and would like to see that information. Now if under contestant # type 7128. This child only competed in 3 events, not all of them. However, the only way I can get it to work is to have it pull each class whether they are in it or not. I would like it to pull only the information that pertains to their names. But it will have to go through every sheet and return their name multiple times since they may be in multiple classes. I hope this makes sense.

**JBeaucaire** · 02-23-2009, 01:51 AM

My question is still unanswered.

You don't show what you're looking accomplish on the invoice instead of what's there. Don't explain it again, lay that out with a sample child (or two) exactly what you want the FINISHED invoice to look like.

Make an extra sheet and mock it up, please.