Index/Match when the Match criteria is based on a second table

Greetings-

First, my apologies if the thread title is confusing. Part of my problem is naming what I'm trying to do. I've searched the web but obviously I'm not asking the right question because I'm not finding similar examples.

Second, it is entirely possible that this belongs in the beginners forum because it is so simple. Sorry.

In this example, Blood1, I wish to find the first instance of each blood type. The result in E13 should be 6/6/94, E14 should be 6/8/94, E15 should be 6/4/94, and E16 should be 6/5/94. Obviously, if column C had a blood type next to each name it would be easy, but in my real-world spreadsheet adding that column would not be practical. Also, the two tables are on different pages.

Thanks for any help.

Peace,
-Dawson

Hello Dawson, I've made a few changes on your submission in order to make it work. Please check if this can help you out with what you need.

https://mega.nz/#!wlYCDLaI!KXPZpgWZC...RwnylmxHVKtI0s


--
Zenarte

These work, but they work by adding the blood type column to the first table. I'm trying to find a way to do it without adding the third column.

Peace,
-Dawson

Originally Posted by JeteMc

This proposed solution also adds a third column, however it adds a earliest date column to the 'other' table (which has been placed on sheet 2 of the attached file), so perhaps that is more acceptable.

This solution is EXACTLY what I needed. The additional column, when added to the second table, is not only "acceptable", it actually adds to the functionality of my workbook in other areas.

I am not Excel-experienced enough to understand exactly what is happening in the array formula, but I have a general idea. It isn't the first formula in my workbook that has me scratching my head, and probably won't be the last.

Thanks!

Peace,
Dawson