"Where" Function
Can the "where" function be used in a lookup formula to limit the rows looked at to only result in values that are not null or only a specific value or partial value? I am attempting to use a lookup...
Forum Discussion
Hi JosephGalvin -
Just making sure you are aware that the lookup function is not a "Left Join" - If multiple rows appear in the resultset - It will only return the first value.
In this case, I recommend either:
- If you want all matching results - Use a custom table and a left join
- If you want one matching result - Add an additional column in the lookup table that would contain the contents of the lookup column only if the lookup result column isn't NULL and use it in the lookup formula
- Another (very non-optimal solution) - Use a SQL statement in your custom column (using a WHERE statement
