Extract/pull data to columns based on 2 criteria

[Lucky_Jackie]

Greetings,

I am seeking an advice related to Microsoft excel 2010,

My tables are shown in the kindly attached photo below,

Tables.jpg

drive.google.com

What is needed, in Table_3,

To populate column [AMOUNT] with values from Table_2 which match Employees Names for a selected month;

To populate the columns [SNO], [EMPLOYEE NAME], [ACC NO.] & [BANK] with values from Table_1 which match a selected option "Internet Banking" in column [PAYMENT METHOD] of Table_1 and bank name selected in Table_3.

(Noted that column [EMPLOYEE NAME] of Table_2 values are referenced from column [EMPLOYEE NAME] of Table_1)

I have tried several formulas related to Index&Match however the columns are being populated with the first match only,

I am trying to automate the process as much as possible. I have spent several days in learning excel however unfortunately I was not successful,

What is the best approach to achieve this that is compatible with Office 2010?

 

[awoohaw]

can you share your data using excel and not an image? Also, Mr. Excel has a tool called XL2BB add in (Link below) where you can post a sample of your work withing a post.

Best Wishes.