Vlook up Max date only for an item with multiple entries with two unique criteria and ret

Looking at the headers below I want to build a look up formula that will result in the latest (most recent date in list) transaction date (A) for a specific transaction type (B) for the MedID (D) for Station (E) and return the associated information in the desired results format listed below the original format.
A B C D E
[TransactionDate] [Transaction] [Med description] [MedID] [Station]

Desired results format
A B C D E
[MedID ] [Station] [TransDate Withdrawn] [TransDate Loaded] [Trans Date Unloaded]

There are 3 transaction types. Loaded, Unloaded and Withdrawn. What I really need to know looking at over 60,000 lines of data: The date of most recent withrawn for a MedID, the most recent Loaded transaction if there is one and finally the most recent unloaded date is there is one line.
Any help, suggestions will be appreciated. Thanks

Insert new columns to do this. So have a new column which runs along the lines of =IF(C2="","",C2) and then 2 more to do the same but with D2 and E2. These columns will only show dates for Withdrawn, Loaded and Unloaded.

Then you can use a lookup to find the MedId for each.

For withdrawn you will be able to use =INDEX(A:A,MATCH(MAX(C:C),C:C,0))
change to D:D and E:E for the other two.

Posting a sample sheet might help

Attached sample file as requested

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

-------------------------------
Your post #5 here means that someone must copy that into a worksheet and try to make sense of it...
To attach a Workbook
(please do not post pictures of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

The dates in your sample are string values not dates so the code convert them to dates
sorts on medit, x-action & x-actiondate
the main part just creates a pivot table,copies to a new location inserts a column for station
and autofills that column with a VLOOKUP to get the station:

Please Login or Register  to view this content.

Your sample file only used one Station ID. I sorted the file by MedID as primary but it can be sorted by other fields for for example Station, MedID, TransDate.
But with present one station sample, there's no way to test that.

I am very sorry for the confusion. I was trying to keep the sample data small and overlooked that. Thank you very much for your help with this.
I am looking for the transaction type and date associated with the MEDID by location. So if there were multiple withdrawn transactions on 6/1/13,6/12/13 and 6/24/13 for ID ABC and these transcations for ABC appeared in Stations #1 and Station #2 I want to see the most recent withdawn data including date for ID ABC in Both station #1 and #2.

Same for the other transaction types.

Thanks!

This one should work:

Please Login or Register  to view this content.

Your date data seems to have both string and numerical values. The modified line in bold should fix that.

Please Login or Register  to view this content.