Forum Discussion

MatsKleemans415's avatar
MatsKleemans415
Copper Contributor
Mar 12, 2022

Which function should I use?

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!

 

Formulas and Functions

2 Replies

  • Vijay__A__Verma's avatar
    Vijay__A__Verma
    Copper Contributor
    Mar 12, 2022
    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.