Question: How to do a lookup using two conditions (i.e., pulling project number on a unique equipment for a specific day)?
Solution: 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.
