Vlookup data and return results on multiple entries

Hey Gang,

So i have a spreadsheet that has a list of members and how many events they have attended. That is fine because i achieved this by doing a countif function on their account number. The spreadsheet has to sheets Events Attended TOTAl and List. In the list it has their name account number and what event they attended and what date. What i need is to have a function that will lookup their account number and return what event they attended but they might have been to 4 different events.

I have a total of 5 columns dedicated to Event attended so we can tell it to lookup first event and return result then have an if function in the next column to lookup event and if its returned in previous column move onto the next event attended.

Thanks to all for their advise in advance
Mikey

This might be what you are after.

Unley, if your data is in a different format and you can't/don't want to change it, post up a good clear set of sample data and we can see if there is a solution for your current setup. If you have a preferred layout for the results, mockup that as well.

Hey Gang,

Thanks to all for the help,
This is what the template looks like
Mine was laid out differently then Dunc's Any Ideas?
Thanks again

Well, you're going to match up those two sheets aren't you? One name cell on the List, but two on the report? That's making your sheet work harder than it needs to. One box or two? Do the same on both sheets and I would opt for 1, that's sufficiently unique.

Maybe something like this will suffice?

Also, you should maybe start with mine. Your sheet had 3megs of hidden data in it.

The reason for 1 sheet having 1 name and the other have 2 fields is because the 1 with two is a generated list that has those members on it. the other one is who out of those members attended different events. If that makes any sense?


I am having trouble getting this too work but i do need it in that format unfortunatley i cannot change it. I am having a brain fart, how do i get { } in front of the formula again.... shift? something right? I am getting the #REF error

Ctrl+shift+enter

The sheet I uploaded is ready to use. Just edit the ranges appropriately and press CTRL-SHIFT-ENTER. If you get errors, post up your book with errors so we can help spot the error.

Will the account number always be only that one person? Or could that same account number show up next to another name?

Since your sample shows the account numbers to be unique, this version works off of that number to create the "events" attended. If that is not the case, please upload a better sampling of data showing the real criteria that must be resolved.

HI Daniel, welcome to the Forum.

Be sure to read through the Forum Rules so you can use and follow them effectively. For instance, you have posted a question of your own in someone else's thread, breaking forum rule #3.

It is to your benefit NOT to do this. Threads as old as this one get little if any attention, so your question will go unseen by many contributors. New threads with properly descriptive titles garner the most attention from the many contributors we have here on the forum.

Start your own thread, give it an accurate title, click GO ADVANCED and use the paperclip icon to attach a sample workbook making it simple for others to see exactly what you want to accomplish.