Hello, all! I'm needing to do a big lookup, and am having trouble getting out of my own way.
A table (AssignmentTable) contains five fields. The first field is Area. The next four are Category1, Category2, Category3, and Category4. Each Category field contains the name of an employee who is authorized to work in that area, on that particular category of project. So think:
Area- Cat1 – Cat2- Cat3- Cat4
LA - Bob - Jim - Andre – Dave
Chicago- Bill- Dan - Steve- Mary
There are many more Areas, this is to simplify the example. I need to build logic that says “If Area = LA and Category = Cat2 THEN Jim.
I’m sure this is easier than I’m making it. Any help would be greatly appreciated!