If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|