'Extract and match multiple rows in google sheets
I'm in Google sheets, attempting to assign the correct Salesforce Account IDs to a LONG list of accounts. I have exported all accounts with IDs, and in another sheet I have a list of opportunities I need to import with DataLoader. However, in order to attach these opportunities to their accounts, they need to have the Account ID.
Essentially I need to take Account Name from each sheet, take the corresponding ID and assign that ID to both Account Names. I am not a developer but I am a Salesforce Admin which does require some basic formula building and I'm more than willing to give anything a shot in order to not have to match them manually, one-by-one. Thanks.
Solution 1:[1]
You need VLOOKUP.
Reorder your columns so the Account Name comes first, then Id. Optionally sort by Name, performance will be better. Think what you'll want to do with duplicate accounts.
=VLOOKUP(E2;$A$2:$B$14;2;false)
the parameters are
- which value,
- against what range (putting dollar signs helps fix the range, otherwise as you drag the formula down it might drag the range down too),
- cell from which column to return,
- is the reference table sorted
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | eyescream |