Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member
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.
Version history
Last update:
‎03-02-2023 08:31 AM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?