Return Vlookup Value if a match is found and date is between 2 values

[mikeb3408]

I have a table similar to below

Event Date	ID	Vlookup Info
2/13/2016	A156	X
1/15/2013	B498

<tbody>
</tbody>

I need to do a Vlookup to another table which has multiple lines of information about the IDs above, and I only want to return the line with info where the ID is matched and the Event Date falls between the Beginning Date and End Date in this other table as shown below:

ID	Beginning Date	End Date	Info
A156	2/10/2016	2/14/2016	X
A156	1/1/2015	1/15/2015	Y

<tbody>
</tbody>

So for in my example above, I would only want to retrieve the Information for the first line since the ID is matched and the Date falls within the range.

I assume I need a combination of Vlookup and If but not exactly sure how to proceed.

 

[mikeb3408]

Glad to hear that. Thanks much for the update.

Hi Aladin,

Quick question. This had been working for me great and recently on my machine when I run this code, if just returns a blank cell instead of workign as it had been. This is even going for your test excel that you put in drop box.

Do you have any idea why this could be?

Really appreciate any help, sorry it has been a little while since the original post

 

[Aladin Akyurek]

Hi Aladin,

Quick question. This had been working for me great and recently on my machine when I run this code, if just returns a blank cell instead of workign as it had been. This is even going for your test excel that you put in drop box.

Do you have any idea why this could be?

Really appreciate any help, sorry it has been a little while since the original post

Hard to tell without seeing the file in which it seems to fail. Did you apply control+shift+enter as you should?

 

[mikeb3408]

Hard to tell without seeing the file in which it seems to fail. Did you apply control+shift+enter as you should?

That was my problem, I was not hitting control shift enter.

Thank you

 

[Aladin Akyurek]

That was my problem, I was not hitting control shift enter.

Thank you

You are welcome. Thanks for the update.