Lucky_Jackie
New Member
- Joined
- Dec 6, 2023
- Messages
- 1
- Office Version
- 2010
Greetings,
I am seeking an advice related to Microsoft excel 2010,
My tables are shown in the kindly attached photo below,
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?
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?