create an excel sheet that can extract data based on three variables comparing two datasets

I am looking for help creating a spreadsheet that will enable me to extract a set of data after comparing three values.

I have attached a sample spreadsheet which I will refer to otherwise I confuse even myself when trying to explain it.

I have two sets of a data a list of times a client called (entered into the ‘WCtable’ table on the ‘Call Data’ sheet) and a list of interactions that were logged for them entered into the ‘INCtable’ table on the reference Data sheet.

There are three things I need to compare to filter out the results I need.

• The name of the client needs to match from the ‘Opened by’ Column on the ‘Call Data’ Sheet with the ‘requester’ column on Sheet ‘Reference Data’

• The name of the person they dealt with needs to also match this is the ‘Assigned to’ column on the ‘Call Data’ Sheet and the ‘opened by’ column on Sheet ‘Reference Data’

• The times of the interactions should be within say 1 Hour of each other so the ‘Opened’ Columns on both sheets.

I have tried doing this with VLookup (failed attempt on the hidden ‘Ignore’ Sheet in the workbook.) But this only returns the first value it finds and some of the clients have more than one and I’m really struggling to think of a straightforward way of trying to marry the instances up other than a lot of nested IF statements but I’m not sure if that will just look for the first value in the column.

Skills: Data Entry, Data Processing, Excel, Visual Basic

See more: import excel sheet sql data base, create excel template import data, create excel sheet, excel compare two lists and return differences, compare two columns in excel for differences, compare two columns in excel using vlookup, how to match data in excel from 2 worksheets, compare two columns in excel, compare two tables in excel, how to compare data in two excel sheets using vlookup, compare two tables and find records with matches, excel, program create excel sheet, create excel form edt data, create excel sheet spring, word macro create excel sheet, create excel sheet using jsp, excel vba extract data web page, create excel sheet access, excel 2007 extract data web page

About the Employer:
( 0 reviews ) United Kingdom

Project ID: #17275471

42 freelancers are bidding on average £28 for this job


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community ( More

£100 GBP in 2 days
(607 Reviews)

Hi there..... Warm Greetings We came along with your request for create an excel sheet that can extract data based on three variables comparing two datasets and we reviewed your project description. We'd like to More

£31 GBP in 1 day
(281 Reviews)

Hello there! This is a basic task which can be done using tools in Excel. We have completed Various similar tasks effectively. Please reply to my bid so that we can discuss further. Thanks Brad

£16 GBP in 1 day
(313 Reviews)
£14 GBP in 1 day
(404 Reviews)

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

£40 GBP in 1 day
(211 Reviews)

Attachment missing! Greetings! It would be easier to implement this requirement (extracting data based on 3 different parameters) using macro. I can come up with a macro using which the data can be extracted as r More

£20 GBP in 1 day
(157 Reviews)

Dear Sir, Greetings. We need to use either index, match, dynamic filter or nested if. I could complete one to show you. Plz let me know if you are interested. Thank you.

£20 GBP in 1 day
(180 Reviews)

Hi I am a very experienced statistician and data scientist. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have do More

£100 GBP in 1 day
(54 Reviews)

I have excellent command on MS Excel formulas and VBA. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place bet automatically on betfair ( More

£40 GBP in 1 day
(60 Reviews)

- Can get compared the WCtable & INCtable’ based on - Name of the client - Name of the person they dealt with based on Assigned to & Call data columns. - And the times of interactions within 1 Hour. This can be More

£100 GBP in 2 days
(48 Reviews)
£50 GBP in 5 days
(55 Reviews)

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.

£20 GBP in 1 day
(46 Reviews)

Let me review the spread sheet with sample data. Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provid More

£20 GBP in 1 day
(71 Reviews)

1. Expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. More

£50 GBP in 1 day
(52 Reviews)

i can create vba script, which will do it automatically

£28 GBP in 2 days
(20 Reviews)

Hi there, I understand your frustration and I have a suggested solution for you. When dealing with database-type tables, you need a database-type data structure and database-type query tools to handle them efficiently. More

£77 GBP in 2 days
(15 Reviews)

I am proficient with excel macro/VBA development, I can write the macro to extract the data as requested in your specification, if you are interested feel free to message me, looking forward to chat further for a quick More

£20 GBP in 1 day
(32 Reviews)

will do sir vlookup I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start and fin More

£18 GBP in 1 day
(16 Reviews)

Greetings, It is expected for the VLOOKUP to fail because it does not consider the future entries in a column. You mentioned an attachment but I can't see it, however by your explanation I believe this can be solved w More

£17 GBP in 1 day
(11 Reviews)

Hi, I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets, More

£20 GBP in 2 days
(9 Reviews)