LookUp with conditions

@nigel could you please invite me as well? I would like to find out, how is the formula workaround made and how it works. I would need some extra filtering functionality in my workspace/database, but not able to do it right now (as baserow does not support it right now) - see my request here:
Lookup data field - limitation if filtering is needed
Thanks!