Need Data from Look Up Column based on Two Search Parameters
I need to grab data from a column but require 2 Search Criterias to be met to do so. A single criteria will produce multiple results. In the example below I need to grab the age of John Doe, so I need to something like: columns["First Name"] === {{first-name}} && columns["Last Name"] === {{last-name}}, columns["Age"]
So my search Parameters the field references {{first-name}} and {{last-name}} need to match up to grab the age from that rows "Age" column.
Best Answers
-
@Michael_329698 I see 2 approaches, depending on your need:
1. Use the **Apply formula to column ** action to create a column that concatenates your two values, then do a lookup
2. Apply a filter that includes all the criteria you need6 -
@Jeff_763648 great ideas! I ended up doing number 2.
So in my example above I did "Apply a Filter" on "John", then did Look Up for "Doe" and that was able to single out the "Age" I wanted to grab.
0