View Single Post
  #8   Report Post  
Domenic
 
Posts: n/a
Default


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