Home

Simple Lead and Sales Match

%3CLINGO-SUB%20id%3D%22lingo-sub-878476%22%20slang%3D%22en-US%22%3ESimple%20Lead%20and%20Sales%20Match%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-878476%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20do%20a%20simple%20lead%20and%20sales%20match%20in%20excel.%20I%20have%20all%20the%20data%20I%20need%20in%20separate%20sheets%2C%20one%20for%20all%20the%20leads%20over%20the%20past%20year%20and%20one%20for%20sales.%20I%20want%20to%20pull%20matches%20by%20stock%20%23%2C%20last%20name%2C%20business%20name%2C%20phone%20%23%2C%20email%2C%20then%20finally%20a%20pull%20which%20has%20matches%20that%20entails%20all%20of%20those.%20Is%20it%20best%20to%20use%20a%20vlookup%20or%20index%2Fmatch%20to%20generate%20a%20list%20of%20cells%20for%20those%20matches%3F%20Do%20I%20need%20to%20format%20my%20data%20in%20a%20certain%20way%20for%20the%20data%20to%20appear%20on%20a%20third%20sheet%3F%20Help%20would%20be%20much%20appreciated!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-878476%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-883416%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20Lead%20and%20Sales%20Match%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-883416%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416160%22%20target%3D%22_blank%22%3E%40RTV22%3C%2FA%3E%26nbsp%3BVLOOKUP%20should%20be%20fine.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAlternatively%2C%20if%20you%20have%20a%20unique%20id%20in%20each%20recordset%20(Stock%20%23%3F)%2C%20then%20you%20can%20create%20a%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FWork-with-Relationships-in-PivotTables-F64EA03B-435A-448D-BC35-3B252BD1233A%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Erelationship%3C%2FA%3E%20between%20the%20tables%2C%20and%20then%20use%20PivotTables%20for%20your%20summaries.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
RTV22
Occasional Visitor

Hello,

 

I want to do a simple lead and sales match in excel. I have all the data I need in separate sheets, one for all the leads over the past year and one for sales. I want to pull matches by stock #, last name, business name, phone #, email, then finally a pull which has matches that entails all of those. Is it best to use a vlookup or index/match to generate a list of cells for those matches? Do I need to format my data in a certain way for the data to appear on a third sheet? Help would be much appreciated!

 

Thanks

1 Reply
Highlighted

@RTV22 VLOOKUP should be fine.

 

Alternatively, if you have a unique id in each recordset (Stock #?), then you can create a relationship between the tables, and then use PivotTables for your summaries. 

Related Conversations
Matching Excel cells by column
ddelise in Excel on
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies
Website OCM
Erico Feitosa in Outlook Customer Manager on
2 Replies
Website Outlook Customer Manager
Erico Feitosa in Outlook Customer Manager on
5 Replies