Call Worksheet Columns Value In Compensation Default And Override Formula

Is it possible to fetch the value from a worksheet column and use it as a parameter to capture a value stored in the UDT to default a different worksheet column?

I know DBI is not available on these worksheet columns but is there any work around?