Another Excel question

Without going the VBA route, is it possible to do the following?

Table A (ID, Start Date, End Date)
123 - 5/10/2011 - 4/20-2012
123 - 5/10/2007 - 5/9/2009
123 - 5/11/2006 - 8/3/2012
473 - 4/23/2008 - 5/18/2011
489 - 6/28/2007 - 7/1/2008
489 - 3/14/2004 - 5/28/2006


Table B (ID, Date2)
123 - 8/28/2008
123 - 5/11/2010
473 - 4/19/2010
489 - 8/25/2006



Basically, I want to ensure that Date2 falls between the date ranges associated with the ID. So my function should return that both 123 Date2s fall between date ranges in Table A, while ID 489 does not fall in between any of the date ranges.

The issue I'm running into is that my function stops after it finds the first matched ID, regardless of whether or not Date2 falls between the Date range. So if you were to search for ID 123, it'd only compare it to the first date range.

Maybe I'm just sleepy or being dumb, but I can't figure out a workaround

5/25/2012 11:00:39 PM

http://office.microsoft.com/en-us/excel-help/how-to-look-up-a-value-in-a-list-and-return-multiple-corresponding-values-HA001226038.aspx

5/25/2012 11:56:44 PM