function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Update using Dataloader_Vlookup



Can you please help me with this?


I have a csv file,


CampaignId      CampaignLocation               Location Id              Location  


100009090                                121                   00001                       121


200000789                                122                   00002                       122


309088877                                 122                           


400007890                                 121  


Campaign and Location are 2 objects. am trying to get campaign location's location id based on location.

Location is the child object for campaign.


In the result, I want this


CampaignId      CampaignLocation                Id               


100009090                                121                   00001          


200000789                                122                   00002          


309088877                                 122                  00002        


400007890                                 121                   00001



am looking for campaign location corresponding value Id.


Please help me this.

 how to apply vlookup for this



Here is what you need to do:


1. In an excel file, in Sheet 1, list the Locations in Column A and Location ID in Column B

2. In Sheet 2 of the same excel file, list the Campaign ID in Column A, Location in Column B and add a new column called LocationID

3. In Row 2 of the LocationID column of Sheet 2, enter the following VLookup formula:


4. When you hit enter, it will bring over the values of the corresponding Location ID from Sheet 1


This should work for you mate! :) Let me know how it goes