Which function should I use?

Copper Contributor

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!

MatsKleemans415_1-1647084397291.png

 

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