Forum Discussion

bbbt123's avatar
bbbt123
Helper I
6 years ago
Solved

look up value not working

Hi, I have to retrieve a value from a different table and I am using this formula:   Column = LOOKUPVALUE(Availability[OnHoliday],Availability[day],lq[deadline],Availability[Email],lq[Email])   ...
Need Help
  • bbbt123's avatar
    bbbt123
    6 years ago

    I figured it our by myself. I write here the solution in case someone has the same issue. Basically my first formula was correct (Lookupvalue searching for multiple criteria,) but it was not working because lookupvalue doesn't work with dates. I have changed the format of the date to whole number and now it is working

bbbt123's avatar
bbbt123
Helper I
6 years ago

I figured it our by myself. I write here the solution in case someone has the same issue. Basically my first formula was correct (Lookupvalue searching for multiple criteria,) but it was not working because lookupvalue doesn't work with dates. I have changed the format of the date to whole number and now it is working

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi bbbt123 , 

    It seems that you solved this problem, right? If so and if you'd like to, you could mark corresponding post as answer or share your solutions. That way, people who in this forum and have similar issue will benefit from it.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.