Get instant live Excel expert help with MATCH Functions

I have a complicated SUMIF problem I think: I want to sum the values in a column only if in 2 other columns, numbers match each other. I.e. if value in A2 matches A3 AND value in D2 matches D3, I want the sum of numbers in C1:C4 added. I've uploaded version of spreadsheet with all columns but with most of the records deleted (it's a large file with >100k records). In my spreadsheet, I want column FK to add up the numbers in column ES only when the values in column A match each other and the values in columns DN match each other.

Hello. I am trying to match up duplicate emails from two columns. However, I am trying to put them side by side (the duplicates) as well as match the dates that associate with the emails.

I have two columns in excel tab. One column is for debit transactions, the other column is for credit transactions. I need to remove the accounts that net to zero. The numbers are listed as posted, so the offsetting amounts are not side by side. For example the debit for $10, (in cell k2) has a credit amount of $0 (in cell L2) but the reversal or offsetting credit transaction for the $10 debit is located in cell L2453. So I need a formula that will identify the amounts in the debit column that match the amounts in the credit column.

I want to match the values of my column and get the result from another column. Plz help

I need to update date from two worksheets. Pull qty to match sku in file with no quantities

I am looking to take a column from one workbook and move it to another but the rows are not aligned. It's names to match addresses

I want to find a value in Sheet 1 - Column A to match with Sheet 2 - Column A. If it is a match, I need to change the value in Sheet 1-Column C with the value in Sheet 2-Column B

Need to update value in Column C of sheet 1 with value in column B of sheet 2 only if value in column A in both sheet 1 and 2 match

We have 2 accounting package that we are running (ACPAC and NETSUITE), we have exported the data into an excel spreadsheet. we are moving another branch over to Netsuite, but some product codes are different for the same item. So we trying to do a comparison that if the item exists in accpac and in netsuite, which a user has manually entered in a column that it does exist, use netsuite's item code on the red sheet column C from orange sheet column C(the lines dont match to do a simple if), but on my one sheet its populating the ACPACS code in the netsuite column. It must only populate a value in red sheet if orange sheet has the "ENTERED" value in Column H

I need to create a dynamic input/output tab based on a variety of variables. I need it to by dynamic and lookup certain values based on others and compute a start/end date. I need the processes (input value) to be kept in a prioritized list and allocated evenly over the employees in order to minimize time spent on all of the projects. Any help/advice you can provide would be great! I want to populate start/end date in the input tab based on the following criteria: Employee: I want to look up employee based on cells A3:A6 in the same tab, Factor # from B3:B6 in the same tab people per process from the same sheet (D15:D33) And I want to match the people with the process time (I have a separate column for each I want the start date and end date to populate starting with the first one being manually entered (9/1/17) and the 1st process has to be the one with Priority #1. I want the processes to allocate in order and evenly distribute among the employees based on their factor allocation time (For example if it's process # 9, it has priority 7 so it should only be started once all other tasks are assigned with no more tahn 2 tasks assigned per time (want this # 2 to trace to a cell where I can change). So let's say FTE #1 gets the task, the time would be 29 MD from the start date so you;d have to loop it through the excel workday function with holidays included (have an example in resource allocation tab) We also have to consider the constraints of the start/end date for all employees