I have 'Visit' object related to Account using Vlookup relation.
I have 10 Accounts and 30 'Visit' records which are related 1-many. While inserting related 'Visit' I need to populate AccountID. I know I need to do Vlookup in Excel before inserting.
But I dont want to do Vlookup in Excel.
I have common field both in 'Visit' and 'Account' object. I need to Vlookup using that common field
Is there any other way so that I can insert with Account__c field in 'Visit' using Dataloader