Problems with the lookupvalue function

[Arial36]

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?

[amitchandak · Accepted solution]

@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]

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!