#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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 |
#4
|
||||
|
||||
No space at all in the formula
|
#5
|
|||
|
|||
Kindly try the foumula for other cells of the column then advise
|
#6
|
||||
|
||||
Awww. Change A6 and C6 to A2 and C2
|
#7
|
|||
|
|||
Thank you very much, the formula works.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Matching a word with variants | gpktm | Excel | 2 | 01-13-2019 03:17 PM |
Index/Matching Problem | sgj74501 | Excel | 5 | 07-28-2016 12:10 AM |
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 |
Record Matching | Excel | Excel | 13 | 08-21-2014 09:44 PM |