No it will not work. Computed columns, like a relation/lookup will only work once the data is written to the table. If you haven’t submitted the form yet, then the data is not in the table, so there will be no lookup to refer to. If you need something like this, you would be better off creating a custom form.