Set reference, find it, find where text matches, bring across value

it will break because there are 3 options

PAYDATE
EFFECTIVE DATE
OFFERS CLOSE

but im hoping.... im good enough to be able to modify whatever the forum throws at me.

i hate loading people up with too many scenarios