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 advice