Lookup formula based on a condition and date timeframe

**wfm007** · 06-14-2013, 11:14 AM

I think this is what you are looking for

**rmitri** · 06-14-2013, 11:28 AM

WFM007,
The formula should have returned Heather in cell C5 and Jen in cell C8 which is not the case.

**wfm007** · 06-14-2013, 11:31 AM

Hi Rmitri,

As per your post, if date & client # matches then it should return to "CATHY".

**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