Is there a way to carry out a lookup based on a condition?
I only want to lookup values from a table where the values in This table's column "Revenue Split" are 0?
I know I can achieve the same thing in a couple of steps but just wondered if I'm missing something?