Hey @BP_Jeremy_Lee, I faced a similar challenge early on when I was working through formulas in Coda. Can you share screenshots of the tables you are talking about? This thread may be relevant for you as you figure out how to use the “Lookup From Table” column format.
This answer from @mallika might be relevant since it sounds like you have dependencies in your tables.