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!