Forum Discussion

NickProp28's avatar
NickProp28
Post Partisan
4 years ago
Solved

Need help on function VLOOKUP

Dear Community,   I would like to create a new column to sum up the total weight from another table. But I dont want the total value are copying to every single row in my new table. I just want to ...
Need Help
NickProp28's avatar
NickProp28
Post Partisan
4 years ago

Dear Greg_Deckler ,

 

I used LOOKUPVALUE, but result that it copying the result to every single row (based on ID) in my table. 
I only need the result show in only one of the record.
Kindly advice

Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

NickProp28 So which record would that be? In other words how do you identify which row you want it in? 

  • NickProp28's avatar
    NickProp28
    Post Partisan
    4 years ago

    Dear Greg_Deckler ,

     

    Any one of the row will be fine. 
    If not doing that, at the end if I sum up the value for example C002, I will get 400 instead of 200.

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      4 years ago

      NickProp28 That's not going to work. This is code. Code is not "hey pick a row, any row", there have to be rules so that the calculation knows when to return a number and when to return blank.

      • NickProp28's avatar
        NickProp28
        Post Partisan
        4 years ago

        Dear Greg_Deckler ,

         

        How about I create another column to state the sequece number, so the calculation can return to first of the ID?