Calculated Column - Receive Value Based on Nearest Date

Hi,    I'm trying to create a calculated column from a second table based on a date value. The goal is to display the actual level for each account before a campaign has been send.    Levels ...