Forum Discussion

bbbt123's avatar
bbbt123
Icon for Helper I rankHelper 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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Kunde = LOOKUPVALUE(Kunde[ID]; Kunde[ID];Angebot[Kunde ID])

Use this code it might help you.

Regards,

Lewis

bbbt123's avatar
bbbt123
Icon for Helper I rankHelper I
6 years ago

Hi, thanks for that but I don't get your code. the labels of the columns do not match my examples