Hi

One way
Enter in cell D2
=IF(ISNA(INDEX($A$2:$C$7113,MATCH($B2,$A$2:$A$7113 ,0),3))
,"",INDEX($A$2:$C$7113,MATCH($B2,$A$2:$A$7113,0),3 ))
Format the cell as date
Copy down as far as D354

--
Regards
Roger Govier



"Data Analyst" wrote in message
...
Hi everyone,

In short, I have Column A with a range of contract numbers from A2:A7113.
Column B has a range from B2:B354.
Column C has a specific date for the contract number in Column B.

I need a formula that take a contract number from Column B and searches
for
it's match in Column A. If there is a match, it needs to enter the date
coinciding with that contract from Column C. If there is no match, then it
should leave it blank.

Although I've tried using the IF statement, I haven't been able to find an
effective formula that includes ranges correctly. Thanks!