LOOKUP WITH TWO CONDITIONS

Follow

Ashley Sutherland

November 05, 2020 21:42

Does anyone know how to do a lookup or something similar using two conditions (i.e., pulling project number on a unique equipment for a specific day)?

1

• 

  Gowtham Senthilkumar November 06, 2020 00:16

  Ashley, 

  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. 

   

  Thanks,
  Gowtham Senthilkumar

  0

  Comment actions Permalink

Please sign in to leave a comment.