Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need a formula to combine two separate reports and add them together to match up certain common criteria. I would like to make a third sheet using the matched up unit numbers and amounts from both reports and label them appropriately with the deposit number from sheet 2, and if possible add the deposit date from sheet 2 as well.
Solved by M. J. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 13/07/2018 - 07:43
Excelchat Expert 13/07/2018 - 07:43
User 13/07/2018 - 07:43
I have only 20 minutes on the clock, and need help lol
Excelchat Expert 13/07/2018 - 07:43
Sure, please provide details about the problem
Excelchat Expert 13/07/2018 - 07:44
You have an option to extend the session also
User 13/07/2018 - 07:44
I have two separate reports that are grouped differently the only common factor are amounts and unit numbers but I dont know how to create a new report or combine the two to be grouped together so they match up
Excelchat Expert 13/07/2018 - 07:44
Can I see the reports, it would help me understand more accurately and provide better solution
User 13/07/2018 - 07:45
ok there they are
Excelchat Expert 13/07/2018 - 07:45
User 13/07/2018 - 07:46
if at all possible i would like the out come to also match up the deposit number from report 2
User 13/07/2018 - 07:46
can you see the reports?
Excelchat Expert 13/07/2018 - 07:47
i can see only one report in sheet 1
Excelchat Expert 13/07/2018 - 07:47
sheet 2 for me is blank
User 13/07/2018 - 07:47
i added it in
User 13/07/2018 - 07:47
i dont know why its not showing
Excelchat Expert 13/07/2018 - 07:48
Now its showing
User 13/07/2018 - 07:48
i will try and figure it out, but i am looking to match unit numbers and amounts and be grouped by deposit number from sheet 2
Excelchat Expert 13/07/2018 - 07:49
So based on units, amount and date you want to combine the data
Excelchat Expert 13/07/2018 - 07:49
Is my understanding correct about the problem?
User 13/07/2018 - 07:50
yes but not the dates, the dates will not alway match
Excelchat Expert 13/07/2018 - 07:50
User 13/07/2018 - 07:50
I am looking to match up units and amounts and then group the whole thing by deposit number on sheet 2
Excelchat Expert 13/07/2018 - 07:51
So, if i can get deposit# in the sheet 1 (separate column) will that work
User 13/07/2018 - 07:52
yes i suppose
User 13/07/2018 - 07:52
as long as the correct deposit number gets added to sheet one, the reports have a lot of different information, not all entries are the same
Excelchat Expert 13/07/2018 - 07:54
give me few minutes while I work on it
User 13/07/2018 - 07:54
thank you
Excelchat Expert 13/07/2018 - 07:59
Also, is it possible that not all values in sheet 1 are found in the sheet 2?
User 13/07/2018 - 07:59
Excelchat Expert 13/07/2018 - 07:59
Here it is
[Uploaded an Excel file]
Excelchat Expert 13/07/2018 - 08:00
I used Vlookup function to get the deposit# in Column N sheet 1
Excelchat Expert 13/07/2018 - 08:00
Have a look
User 13/07/2018 - 08:01
It looks like what I need but wont know for sure until I start ticking and tying out these items. Is there a way for me to now organize them by deposit number?
Excelchat Expert 13/07/2018 - 08:02
Yes, sorting
Excelchat Expert 13/07/2018 - 08:06
Here's the sorted file
[Uploaded an Excel file]
User 13/07/2018 - 08:07
was that in sheet one or two?
User 13/07/2018 - 08:07
sheet two looks like how i sorted it
Excelchat Expert 13/07/2018 - 08:07
sheet 1
User 13/07/2018 - 08:07
thats what i meant sorry
User 13/07/2018 - 08:07
ok, thank you for your help!
Excelchat Expert 13/07/2018 - 08:08
This solves your problem?
User 13/07/2018 - 08:08
Again I wont know until I spend much more time looking at it. but thank you
Excelchat Expert 13/07/2018 - 08:09
You are Welcome

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc