Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

LOOKUPVALUE does not return all values

Hello to all   This is in fact a strange one (or not): I'm using LOOKUPVALUE with the following data (ITEM): ID  TID  Previous Status 1   2       A 2   2       B 3   2       C 4   3       A ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks Greg_Deckler

I also red that.. but for me the values are in fact diferent... I assumed that the behaviour was not the one you describe.

 

So..

 

A Filter/Calculate to get this one?

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

Are the 2 tables related? Seems like if you relate them ITEM[Previous Value] > GROUP[Status] that this problem becomes trivial. Or are these 2 tables already related some other way?

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Even more perplexing, I implemented your formula as a Column in ITEM table and it worked perfectly, got all of the group names. This was with completely unrelated tables. So, I'm guessing that you do in fact have a relationship between the tables and that is what is messing with your formula.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Yep... bu I tried the same with a "new" table that withou relation and the result was the same...

       

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        7 years ago

        I attached my file, tables 34 and 35. I'd have to understand how the tables are related to probably tell you how to solve it.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Greg_Deckler they are related in other field.

     

    So I think I can not use what you refer.