Forum Discussion
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 ...
is this what you want? pls see the attachment below
NickProp28 You can use LOOKUPVALUE or MAXX(FILTER(...),...) for that.
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 adviceNickProp28 So which record would that be? In other words how do you identify which row you want it in?
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.
