Forum Discussion
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, and I need that, for all the parts that are in both tables, it brings me the date from the second table to the first. The problem is that when I use the lookupvalue formula it gives me the following error "a table of several values was provided where a single value was expected". The strange thing is that if I want to bring any other field from the second table there are no problems and the function works perfectly. Only when I want to bring the date field to me does this error happen. What could be happening?
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
2 Replies
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=czNHt7UXIe8Thank 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!
