I need to lookup a value from another table but need to base the lookup on two columns. Any suggestions on how to do that?
A lookup is basically a simplified merge. You can use the “Merge” action (in the lookup mode) to match values in 2 or more columns.