How to compare data from two different data sets

[Anonymous]

I have a main set of data and then I have a much smaller document of exceptions. Both data sets share Load ID, PU value, and DEL value. The data sets are connected by Load ID.

I'm trying to search each load ID from the main set against the load ID's in the exceptions data. If the load ID appears in the exceptions data then I want to set my new column in the main set "Actual missed PU" to the value that the exceptions data has and if not keep it the same. 

It's comparing the ID's fine but when I go to try and grab the PU value it says that it can't find the exceptions data table. Is there a function I need to use to reference the other data set or what am I missing here?

[Anonymous · Accepted solution]

Never mind figured it out via Lookupvalue

[Anonymous]

This is the function I'm trying to use. Table1 is the exceptions dataset, RROrders_view is the main data set.