Need help with a formula lookup/rollup

Any chance you could provide some screenshots and an example of what you'd like to happen?  Would love to help but don't fully understand your setup, sorry!

Hi, thanks for the response. I'm able to get the values to rollup but I don't know how to get the matching contractor to populate with their value. I tried to concatenate that one field but it's grabbing the entire table instead of the top performer. 

Ah, thanks for the details!

Hmm, perhaps you could try this:
1. In Table 1, create a lookup field to display the field "Top Performer - union"
2. In Table 1, create a formula field that checks whether the "Top Performer - union" lookup field from step 1 matches the field that you're using for the rollup field "Top Performer - union"
  - This should result in a single record outputting "true" or some such
3. In Table 2, create a conditional lookup field that will display the name field of the record only if the formula field from step 2 outputs as "true"

Here's something similar to get you going

Thank you for your response, I'm still working on it. I can get a date and time to do what I want but, for whatever reason, I can't get a currency and name to do the same. 

Roger that.  Could you share some screenshots of the issue you're facing?

Sure, thanks! I have a lot of tables on this one but in this picture, I can grab the highest number but i don't know how to grab the matching contractor. 

Thanks, could you provide screenshots that show the following two items?

1. In Table 1, the  lookup field that displays the field "Top Performer - union"
2. In Table 1, the formula field that checks whether the "Top Performer - union" lookup field from step 1 matches the field that you're using for the rollup field "Top Performer - union"