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 dummy data.
Go to Solution.
@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.
View solution in original post
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.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.