Index Match Help??

[kcgojnur]

Hello,

I'm wondering if index match will help me or do I need to go another route. I have a few columns of data. In column A and C I have employee ID numbers in which I have to see how many match. In column B I have task closed dates. I'm trying to find the id numbers that match in column A and C and if there is a match pull the task closed date from column B. Any suggestions?

Employee ID A	Task Closed Date	Employee ID B	Output
1234	03/10/19	1478	01/02/20
1111	05/20/19	1234	03/10/19
3211	06/06/18	9635	N/A
1478	01/02/20	1111	05/20/19

 

[JoeMo]

Extend the ranges in the formula below to match your data.

Book1
	A	B	C	D
1	Employee ID A	Task Closed Date	Employee ID B	Output
2	1234	3/10/2019	1478	1/2/2020
3	1111	5/20/2019	1234	3/10/2019
4	3211	No Match	9635	N/A
5	1478	1/2/2020	1111	5/20/2019
Sheet4

Cell Formulas
Range	Formula
B2:B5	B2	=IF(ISNA(MATCH(A2,$C$2:$C$5,0)),"No Match",VLOOKUP(A2,$C$2:$D$5,2,0))

 

[kcgojnur]

Not sure what's going on. Instead of it pulling dates it's pulling random #'s. Basically, if C=A then I need to pull that date. For example C30=A425 then I should have the date that exists in B425.

 

[JoeMo]

are you sure the "random" numbers are not date serial numbers? If not, be sure to format the cells the formulas are in as Dates, not General or numbers. Also, have you extended the ranges to cover all your data? If so, can you post the formula you are using?

 

[kcgojnur]

So I modified a few cells where the id's match and even modified the date. The formula remains same. No change.

 

[JoeMo]

Can you answer my questions in post #4?

 

[Fluff]

Cross posted Index Match or Something Else??

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.