4 Replies Latest reply on Oct 19, 2018 12:15 AM by Ankit Bansal

    Return date value from one column based on lookup from another column

    Vivian Horng

      Hi All,

       

      Just wondering if anyone can help me out with a lookup calculation. Somehow the result keeps showing up as null for me. I tried this formula: if [column A] = "wed" then [column B] else null end. Please let me know if you have any solutions!

       

      Column A      Column B

      abd                  9/1/18

      bjh                   10/1/18

      ejh                   11/1/18

      wed                 12/1/18

      ick                    4/1/18