hi all,
I am trying to use Index Match formula on 2 spreadsheets. There is 2 text
fields and a date field which I need to match b/w the s/s.

Problem 1: when I try to match on the 2 text fields, I dont have a problem.
Once I add in the date field, I don't get any results.

Problem 2: When I try to match on 2 text fields, I get some results back. I,
then retype in the formula for those with #NA and some results pop up. Why
did it not throw out the results the first time around?

Problem 3: When I run index match on sheet 1 and sheet 2 (cross checking the
results), the results are different/inconsistent.

Can someone help me resolve the above problems?