Lookup formula based on a condition and date timeframe

**Tony Valko** · 06-14-2013, 11:32 AM

Originally Posted by rmitri

WFM007,
The formula should have returned Cathy in cell C5

I think the correct result should be Heather.

That's what my suggestion returns.

**Tony Valko** · 06-14-2013, 11:38 AM

Here's a small sample file that demonstrates this...

rmitri.xlsx

**rmitri** · 06-14-2013, 01:17 PM

Worked perfectly Tony, exactly what I was looking for.
Thank you.

**Tony Valko** · 06-14-2013, 01:56 PM

You're welcome. Thanks for the feedback!

Re: Lookup formula based on a condition and date timeframe