Matching Value to Maximum Date in a Range

Sorry for off-topic interjection:

Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

Thanks again for all your hard work here!

If the file that you are trying to attach is related to your other Vlookup query thread, https://www.excelforum.com/excel-for...lumn-data.html then you should attach your file to that thread and continue there. Starting multiple threads for the same question is against forum rules.

Not certain what you are talking about. I posted the questions and one of the options was to upload a (related) file, which I did.
So what;s the problem?
Did my question get posted at all? Was the uploaded file received?
The question could have been answered without the attached file but I thought that by providing the file it would make it easier to see what I was attempting to resolve.

Originally Posted by USAOz

Not certain what you are talking about. I posted the questions and one of the options was to upload a (related) file, which I did.

When I looked at your thread there was no file, just a single line of text, something like 'see attached'

Originally Posted by USAOz

So what;s the problem?

there was no question, just an almost empty post. This suggested that your question and any explanation of your problem would be located in the file you were trying to attach.

For this reason, I used a canned (pre-written) reply to inform you that we prefer if you only use attachments for data samples and that your question / explaination is entered directly into the thread. Given that there is only one canned reply which is worded so that it can be used for both questions and answers, I appreciate that it could be a bit misleading.

Originally Posted by USAOz

Did my question get posted at all? Was the uploaded file received?

The thread was created but it contained nothing meaningful.
Given that the only thing with any meaning was the mention of vlookup in the title, it appeared that you might have been restarting your previous question. For this reason, I added an extra comment to advise you that you should not start a new thread if that was the case. Given that you have now started another thread, which I have flagged as duplicate for locking, you clearly didn't understand this, so I guess maybe you neglected to read the rules that you agreed to follow when you joined the forum.

Originally Posted by USAOz

The question could have been answered without the attached file but I thought that by providing the file it would make it easier to see what I was attempting to resolve.

Possibly, but not guaranteed. In most cases the answer is only as good as the question. More often than not there is a significant difference between an answer and a solution.