Forum Discussion
Solved
Problems with the lookupvalue function
Hello Community! I am having a problem with the lookupvalue formula. I have a table that contains a field with part numbers. In turn, I have another table with part numbers as well and a date field,...
Arial36 , Can you share sample data and sample output in table format?
I think there is more than one value in another table.
There 4 ways to copy data from one table to another.
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
Arial36 , Can you share sample data and sample output in table format?
I think there is more than one value in another table.
There 4 ways to copy data from one table to another.
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
Thank you ! Watching the videos I could solve it with this formula:
IF Date = MAXX (FILTER ('Total ML Pieces', 'Total ML Pieces' [Bar] = 'Divergent Pallets' [Bar]), 'Total ML Pieces' [IF Date])
Greetings!