Forum Discussion
LOOKUPVALUE missing identical lookups
Hello can someone help me. Why are more than half of the values missing from this simple vlookup. If one works they should all work. I even use trim function in wbs_blank_fix. My lookup table for thi...
Anonymous LOOKUPVALUE will "fail" if there are multiple matches. Try using MAXX( FILTER( ... ), ... ) instead.
Greg_Deckler
Community Champion
Community ChampionAnonymous LOOKUPVALUE will "fail" if there are multiple matches. Try using MAXX( FILTER( ... ), ... ) instead.
Okay will try tomorrow, but I will add this project code is unique in the lookup table and I already used this lookup successfully in another table in the same model. So it is very wierd to me.