Using LookupValue to retrieve max in separate tables - without using a calculated column

I have two columns containing data (in separate tables):     I have been able to retrieve the percentage value for the max percentage, but how do I go about doing the same for the actual amo...