mzehr Wrote:
Hi Domenic
I think I have it - as I put in my last post to Boggled:
=INDEX(((Date)*(Name="Joe")),MATCH(MIN(ABS(((Date) *(Name="Joe"))-TARGET)),ABS(((Date)*(Name="Joe"))-TARGET),0))
where Name is the range of Names (A1:A4)
Date is the range of Dates (B1:B4)
And Target is the lookup date you are searching for.
I also tested it with exact date match, no problem. Thanks for your
input
as well!
Mike
Hi Mike!
Yes, your formula seems to work fine. When I discovered the problem
with my formula, I tested it against yours and found it returned the
correct results. :)
Cheers!
--
Domenic
------------------------------------------------------------------------
Domenic's Profile:
http://www.excelforum.com/member.php...o&userid=10785
View this thread:
http://www.excelforum.com/showthread...hreadid=273186