Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Vinny12Vinny12 

Update using Dataloader_Vlookup

Hi,

 

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

Thanks.

AroraAnupAroraAnup

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:

  =VLOOKUP(B:B,Sheet1!A:B,2,FALSE)

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