Is it possible to use an If statement to perform a lookup?
Matter Table has {Entity Name}
Entities Table has {Legal Entity} and {Principal Place of Business}
I want to automatically populate {Address} in Matter Table with {Principal Place of Business...
Isn’t that just a regular lookup? What I’m looking for is something like this:
If ({Entity}= {Legal Entity in Entities Table}, then Address = Lookup Address in Entities Table
I think the way you’re suggesting requires a person to select the appropria...
No doubt it’s me. I was unaware of a vlookup. But correct me if I’m wrong — from the brief exploration I’ve done on vlookup, it’s not an actual field I can select but requires some organization/manipulation with different tables that I’ll have to do ...
