Comparing columns on separate sheets and putting the result from an adjacent cell on the first sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1109736%22%20slang%3D%22en-US%22%3EComparing%20columns%20on%20separate%20sheets%20and%20putting%20the%20result%20from%20an%20adjacent%20cell%20on%20the%20first%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1109736%22%20slang%3D%22en-US%22%3E%3CP%3E'Sheet1'%20has%20a%20list%20of%20phone%20numbers.%20'Sheet2'%20has%20the%20same%20list%20of%20phone%20numbers%2C%20but%20duplicated%20many%20times%20with%20different%20types%20of%20service%20charges.%20The%20goal%20is%20to%20match%20a%20phone%20number%20from%20'Sheet1'%20with%20an%20identical%20phone%20number%20from%20'Sheet2'%2C%20and%20copy%20from%20'Sheet2'%2C%20the%20data%20from%20another%20column%20in%20the%20same%20row%2C%20to%20another%20column%20in%20the%20same%20row%20as%20the%20phone%20number%20on%20'Sheet1'.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20the%20formula%20for%20this%20ASAP%20or%20I%20will%20have%20to%20do%20this%20manually%20for%20over%20300%20phone%20numbers%20on%20Sheet1%2C%20with%20over%206900%20phone%20numbers%20on%20Sheet2%2C%20before%20this%20Friday.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1109736%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1109763%22%20slang%3D%22en-US%22%3ERe%3A%20Comparing%20columns%20on%20separate%20sheets%20and%20putting%20the%20result%20from%20an%20adjacent%20cell%20on%20the%20first%20s%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1109763%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can%20try%20vlookup.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F519247%22%20target%3D%22_blank%22%3E%40spfldnet%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

'Sheet1' has a list of phone numbers. 'Sheet2' has the same list of phone numbers, but duplicated many times with different types of service charges. The goal is to match a phone number from 'Sheet1' with an identical phone number from 'Sheet2', and copy from 'Sheet2', the data from another column in the same row, to another column in the same row as the phone number on 'Sheet1'. 

 

I need the formula for this ASAP or I will have to do this manually for over 300 phone numbers on Sheet1, with over 6900 phone numbers on Sheet2, before this Friday.

1 Reply
Highlighted