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.
Update MAXX indeed did the trick and fixed my issues, thanks for the help