Using Index and Match For Multiple Criteria Mismatch Data Type

[shelby55]

Hi

I am using Excel 2003.

How do I combine an index and match formula for arrays where the data fields are not the same i.e. one is text and one is date.

The formula of:

=INDEX(Ttl_Sick_MOS,MATCH(A14,MyDates,0))

works but it is finding the first occurrence of the month and not also matching to department.

It looks to me like filtering the raw data sheet doesn't matter for selection of my data because my indexes etc. aren't looking at only the filtered data, it is looking at the entire worksheet anyway thus the need to match both.

Any assistance greatly appreciated - thanks.

 

[SkipVought]

as posted

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

and furthermore, if you had done it manually, and recorded it as advised, you would have had this code.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[shelby55]

Hi

I don't understand what you mean by "doing it manually"...I've done all that I understood you to ask me to do. I'm not sitting around waiting for answers....but your directions have not been easy to understand.

AND I STILL DON'T SEE WHERE THE INFORMATION IS POSTED AS PER YOUR LAST POST

 

[SkipVought]

2 Nov 10 22:44 in yor other thread has the code

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}