Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-18-2020, 01:02 AM
Mukapa Mukapa is offline Selecting a value after matching two conditions Windows XP Selecting a value after matching two conditions Office 2003
Novice
Selecting a value after matching two conditions
 
Join Date: Jan 2016
Posts: 10
Mukapa is on a distinguished road
Default Selecting a value after matching two conditions

Greetings,
I have a table of values that I want to match with another table then a wanted value is displayed, I explain myself:
In a table (table1) containing identification number of clients and the month they paid, I want excel to search those two values in another table which contain amount paid. If identification and correct month is found, then excel should display amount paid for that month.


On attachment, I put an example of my two tables and what I want to be displayed in table1.
Thank you in advance for your help.



You have helped me in so many queries, I really appreciate
Attached Files
File Type: xlsx New Microsoft Office Excel Worksheet (2).xlsx (11.1 KB, 5 views)
Reply With Quote
  #2  
Old 02-18-2020, 02:08 AM
Marcia's Avatar
Marcia Marcia is offline Selecting a value after matching two conditions Windows 7 32bit Selecting a value after matching two conditions Office 2013
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

In D2 of Table 1, paste this formula
=SUMIFS(table2!$D$2:$D$10,table2!$A$2:$A$10,$A6,ta ble2!$C$2:$C$10,$C6)
Copy down
Reply With Quote
  #3  
Old 02-18-2020, 02:55 AM
Mukapa Mukapa is offline Selecting a value after matching two conditions Windows XP Selecting a value after matching two conditions Office 2003
Novice
Selecting a value after matching two conditions
 
Join Date: Jan 2016
Posts: 10
Mukapa is on a distinguished road
Default

Thank you very much Marcia for your feedback. the last "table2" in the formula contain a space?. I used it without space and i got a correct value in D2. Howerver by scrolling down other values were "0". Thank you for your help though
Reply With Quote
  #4  
Old 02-18-2020, 02:56 AM
Marcia's Avatar
Marcia Marcia is offline Selecting a value after matching two conditions Windows 7 32bit Selecting a value after matching two conditions Office 2013
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

No space at all in the formula
Reply With Quote
  #5  
Old 02-18-2020, 03:02 AM
Mukapa Mukapa is offline Selecting a value after matching two conditions Windows XP Selecting a value after matching two conditions Office 2003
Novice
Selecting a value after matching two conditions
 
Join Date: Jan 2016
Posts: 10
Mukapa is on a distinguished road
Default

Kindly try the foumula for other cells of the column then advise
Reply With Quote
  #6  
Old 02-18-2020, 03:17 AM
Marcia's Avatar
Marcia Marcia is offline Selecting a value after matching two conditions Windows 7 32bit Selecting a value after matching two conditions Office 2013
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Quote:
Originally Posted by Mukapa View Post
Kindly try the foumula for other cells of the column then advise
Awww. Change A6 and C6 to A2 and C2
Reply With Quote
  #7  
Old 02-18-2020, 05:26 AM
Mukapa Mukapa is offline Selecting a value after matching two conditions Windows XP Selecting a value after matching two conditions Office 2003
Novice
Selecting a value after matching two conditions
 
Join Date: Jan 2016
Posts: 10
Mukapa is on a distinguished road
Default

Thank you very much, the formula works.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Matching a word with variants gpktm Excel 2 01-13-2019 03:17 PM
Selecting a value after matching two conditions Index/Matching Problem sgj74501 Excel 5 07-28-2016 12:10 AM
Selecting a value after matching two conditions Matching last in a list salse Excel 3 06-08-2016 08:08 PM
Mis-matching merge fields BarbNH Mail Merge 8 01-09-2015 01:56 PM
Selecting a value after matching two conditions Record Matching Excel Excel 13 08-21-2014 09:44 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:09 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft