Index Match Function To Pull Multiple Consistent Rows of Information Rather Than 1st One

Welcome to Excel Forum.
Please upload a sample of the spreadsheet rather than screen shots of the spreadsheet. For one thing the first and third screen shots are hard to read. For another it is easier to test possible solutions on a spreadsheet so that it is more likely to get a working solution sooner rather than later.
To attach a sample workbook, make sure there is enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (the paperclip icon doesn't work).
With all of that said, and if you want to work further on the issue yourself, it sounds like an Index/Iferror/Small or Index/Small(If... combination will perhaps give you a more suitable formula for your needs.

Waited for a while to see if 'another pair of eyes' could spot something that I can't.
The only thing that I can see, which is probably trivial, is that the formula in Export Tab!I8:I9 isn't the same as in I4:I7.
I am left to guess that you would like the Export Tab!I9:L9 to be filled with the values from Accounts!N9:Q9. Seems that the reason that doesn't happen is that Accounts!S8 = Accounts!S9 and the formula in Export Tab column A precludes that type of duplication.
There may be something that I am missing, if so please provide the information.
To me it seems the issue is about logic, as in another differentiating factor needs to be added to the values in column S of the Accounts sheet. Unfortunately I don't know enough about the workbook to offer a suggestion as to how that issue could be addressed.

crossposted: http://www.excelguru.ca/forums/showt...out-Duplicates

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

Also cross posted at http://www.mrexcel.com/forum/excel-q...uplicates.html

In the file attached to post #5 the results that are currently being given are shown. What might help is to also show the results that you want displayed as well as a brief explanation of what criteria should be used.

Sorry I was referring to the file Test 5.xlsm attached to post #3.

Couldn't come up with a 'Clean' solution, that is one formula that could be entered in J4 and copied down and across to M8. This proposed solution has three parts actually, column J is populated by using the array entered formula:

Formula:

=IFERROR(INDEX(Accounts!N$4:N$14,SMALL(IFERROR(ROW(A$1:A$14)/((Accounts!$S$4:$S$14=$A4)*(Accounts!N$4:N$14<>"")),FALSE),2)),IFERROR(INDEX(Accounts!O$4:O$14,SMALL(IFERROR(ROW(A$1:A$14)/((Accounts!$S$4:$S$14=$A4)*(Accounts!O$4:O$14<>"")),FALSE),1)),""))

Columns K and L are populated using the array entered formula:

Formula:

=IFERROR(INDEX(Accounts!O$4:O$14,SMALL(IFERROR(ROW(B$1:B$14)/((Accounts!$S$4:$S$14=$A4)*(Accounts!O$4:O$14<>"")),FALSE),1)),IFERROR(INDEX(Accounts!P$4:P$14,SMALL(IFERROR(ROW(B$1:B$14)/((Accounts!$S$4:$S$14=$A4)*(Accounts!P$4:P$14<>"")),FALSE),1)),""))

Column M is populated using the array entered formula:

Formula:

=IFERROR(INDEX(Accounts!Q$4:Q$14,SMALL(IFERROR(ROW(D$1:D$14)/((Accounts!$S$4:$S$14=$A4)*(Accounts!Q$4:Q$14<>"")),FALSE),1)),"")

*Array entered formulas are activated by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Another thing that I should mention is that the formulas don't block duplicates (K4 and M8) so a conditional formatting rule is applied to the range J4:M8 which matches the font to the fill, in this case yellow, and hides the duplicates using the formula:

Formula:

=COUNTIFS($I4:I4,J4)>0

Let us know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment, when you are able, and mark the thread as 'Solved' using the thread tools link that is above your first post. I hope that you have a blessed day.

I not sure what you are referring to. In my copy of the spreadsheet, attached to post #12, there are four registration holders listed in row 8 of the export tab, which match the four names in row 9 of the accounts sheet.

Not a problem. I hope that you have a blessed day.