Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index Match Inconsistencies
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index Match Inconsistencies
Hi J,
I think you need to provide some examples of your data and the formulae you are already using, along with the results you expect to obtain. fields and a date field which I need to match b/w the s/s. Beware the SS? I'll keep that in mind... Cheers Steve D. "Office Girl J" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
index,match,match on un-sorted data | Excel Worksheet Functions |