Forum Discussion
adityavighne
Continued Contributor
Continued ContributorLookup value when 2 conditions meet
Hi, I have two table: Table 1 contains (ID, Email) and Table 2 contains (ID, Email, Usage) I want lookup value Usage in Table 1 when two conditionas are meet: ID and Email below is sample dumm...
adityavighne As you have same ID for different email ID so you'll need to create a Key column in both the tables.
Step 1: Create Key column (combining ID and Email) in Table 1.
Key = DATA1[Email]&DATA1[ID]
Step 2: Create the Key Column in Table 2:Key = DATA2[Email]&DATA2[ID]
Step 3: Create Bridge Table to join these Key columns:
Step 4: Then Create calculated column to find relevant usage.
Lookup = IF(DATA2[Key]=RELATED(Bridge[Key]),DATA2[Usage],"-")Output:
Hi,
I guess you could consider the brute force of creating a new hybrid key in each table by concatenating the ID and Email fields and then narrowing back the problem to a lookup on a single key with LOOKUPVALUE.
Curious to see if there's something more elegant.
Best
CBO