Forum Discussion
- PeterBartholomew1Silver Contributor
In recent versions of Excel you would use
= XLOOKUP(salesforceID, serverID, email, "Not found")
Scenario: There are 3 columns: A, B, and C.
Please see the picture below.
Example 1: A9 = B6 = 8888, so I want to get C6.
Example 2: A3 = B7, so I want to get C7.
Is there a formula to find this? Thanks!
In recent versions of Excel you would use
= XLOOKUP(salesforceID, serverID, email, "Not found")