Forum Discussion
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 show the value in only one of the ID.
My expectation:
Table 1
New table (vlookup) - Based on the ID
Thank for your attention. Any help will greatly appreciated.
is this what you want? pls see the attachment below
13 Replies
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?
