Which function should I use?

Occasional Visitor

Hi guys, 


I have a question, I have some really big data sets and I want to find some dates. However I don't know which function I should use I tried the IF function many times to find the harvest date from the code in Colum D, my formula was then =If(C:C;B:B;D2). This didn't result in the factor in the date that I want to get out. 

Any of you guys know how I can get the date from such data set? (this is just an example I have to do this from thousands of numbers). 


Thank you for helping me!



2 Replies
It's not a matter for IF() but for lookup functions like XLOOKUP().
Put this formula
The result may be returned in number format. If it does, format the result as date.