Lookup With Two Conditions
Question
How to do a lookup using two conditions (i.e., pulling project number on a unique equipment for a specific day)?
Answer
You can only use one field as the key field in Lookup function. So, it is better to create a combined key (using concat or '+') with Equipment in both the tables as Custom Columns and then, use the newly created field to perform the lookup.
Published 10-16-2021
