Vlookup for multiple rows to create a temporary range?

[soclose]

Hopefully I can explain what I am trying to do, I have tried to google, but I feel I don't have the right words.

I have two sheets in a book. In sheet one I have each "guest" as a type of members register.
In one of the columns I am using COUNTIF to tally up the number of rows (meetings) that guest has in sheet two, the big list of meetings.
That works well and I can see on sheet one that I met Bob 3 times and Ann 5 times.
I would like to also see at a glance when we most recently met. So in other words, use a MAX on "all the dates in C:C that have Bob in col A:A"

Does this make sense at all? Otherwise please let me know and I will try and be clearer.

Here's an example file: ListTest2.xlsx

[mikeTRON]

Welcome to the forum.

Typically if someone wants help they will post a sample workbook (follow the instructions in my signature).
In this workbook they will include sample data that is representative of the actual data (or you can use actual data if it is NEAT and easy for us to understand AND NOT SENSITIVE).
Also in the workbook, is a layout of exactly what they want the output to look like. Give us an example of what you are trying to do and you can use typed numbers and tell us you are looking for a formula to populate a cell or a specific range.

This will help us help you.

[soclose]

Thanks! Have edited my post to include a test file.
I should perhaps have adjusted my example given then to say that in contacts!J2 I want to see the latest date on which I met the person with the nick in contacts!A2. That person has two dates in meetings!C and I would like to pull up the most recent of the two so it dynamically updates as more and more dates are added.

[mikeTRON]

So I am not EXACTLY sure which is the unique key on each of the tabs (I was expecting there to be a name, but I think the "number" column is unique).

Either of these two formulas will work in cell J2 assuming the data in the MEETINGS tab is sorted in order of oldest to newest:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[soclose]

Yeah, sorry, number would be the key. I suspected INDEX would be part of the solution to this. Will need to analyse this to work out why it works :D
Huge thanks for the fast reply!

What would I need to add to it to make it return the value of "next meeting" for the row that contains the latest meeting?

[soclose]

Hmm, the first alternative doesn't use MAX, so I can't "reverse engineer it" to use MIN ... maybe I should use the second example instead?

[mikeTRON]

Hmm, the first alternative doesn't use MAX, so I can't "reverse engineer it" to use MIN ... maybe I should use the second example instead?

What are you trying to accomplish?

[mikeTRON]

simply change the column from =INDEX(meetings!C:C, to whatever the next meeting column is on the meetings tab.

[soclose]

Thanks for the help mikeTRON this is working pretty well for me now will be interesting to see it in action!

[mikeTRON]

Great, let us know if you need any additional help or have any other questions.

Can you also mark the thread SOLVED?