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
|