That's interesting. I will look into that.
Another question, is there a way to set run conditions that are on a separate table?
When column in table 1 contains text, run this column in table 2.
That’s awesome. I’ve used lookup many times before but never thought of using it to pull information into the table.
I’ve always used it as a database check. This will work perfectly.