Forum Discussion
Need help on function VLOOKUP
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
NickProp28 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.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.