This is probably too late to comment for your research but I’ve found the lookup features very confusing and I’m almost giving up on using coda because of it. I wish there were a ton of examples. Very hard to figure out even the simplest lookup.
Update: this post really helped me: https://community.coda.io/t/lookup-from-other-table/1284/6