In your function "MatchOneBack":
Code:
        ...
    LookupValue = ValueOneBack
    'Add Here:
    MsgBox LookupValue.Address
        ...
This will pop up a message box with the Address of the Range Object that is returned by the call to the ValueOneBack function.