PROBLEM: I have a mass of data in an excel spreadsheet that I need to correlate with another Excel spreadsheet, and export the "overlap" between the two spreadsheets to a new spreadsheet.
THE DATA: The spread sheet has many columns but I only care about 4 columns. The other spreadsheet is not as large as the first and definitely manageable.
MY "SOLUTION": I want a VLookup or Match script that will search the data, correlate between the two spreadsheets and export the selected result to a new spread sheet. (You can suggest a different approach if my solution is not the best.)
49 freelancers are bidding on average $25 for this job
Hi there, This looks feasible and I can use array or SQL queries to make it fast and efficient. I am expert in Excel VBA with over 5+ years of experience. Ping me to discuss more about the project. Thanks Aman
Hi ! Let me help you i will check which formula will helpful for getting require results. Thank you ! Relevant Skills and Experience Have 5 years of excel exp Proposed Milestones $10 USD - excel work
Hi, The VLookup will do good, but we can also go with vba script, if the need be. Either way,I can start the work right now and will deliver in a couple of [url removed, login to view] me please.Thanks.