Forum Discussion

MSW's avatar
MSW
Icon for Helper I rankHelper I
4 years ago

lookupvalue no longer working after Data Refresh

I have a simple Vlookupformula for two columns in Table2. The values are in Table1 and appear to be present. It was working well until I did a data refresh recently all of a sudden it is no longer retreiving any values. Nothing should have changed with the refresh. What could be the cause of this malfunction? 

5 Replies

  • MSW's avatar
    MSW
    Icon for Helper I rankHelper I
    4 years ago

    Resolved. Not sure why it was not working the same as previous but I built another table with the unique IDs and the column value and referenced that table instead to lookup the value into the target table.

  • m3tr01d's avatar
    m3tr01d
    Icon for Continued Contributor rankContinued Contributor
    4 years ago

    MSW Most likely, when you refresh the model, you added duplicate values in your lookup table. Lookupvalue will return an error if there are duplicates.

    • MSW's avatar
      MSW
      Icon for Helper I rankHelper I
      4 years ago

      m3tr01d Thank you for the reply. I had duplicates before and it was working. Im not getting an error message its returning nothing at all now. As if the formula is not even there. I have tried making a new column and re-write the formula too. 

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion
    4 years ago

    One of the best ways to test lookupvalue is to hardcode the value to be searched for so try putting a value that you know exists as your search term.

    if no result value is returned, you can investigate the field that was expected to match (see if there are spaces in it or hidden characters etc)

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I am having the same problem too. Started no more than 2weeks ago