If Statement (Match/Index)

Good Morning,

i am trying to automate a sheet which is completely done manually till now, below is the scenario

2 sets of sheets

Sheet 1 is raw data and sheet 2 is the summary or status of the facilities

Sheet 2 banking liabilities or facilities
i have to calculate automatically how much we have used from our business finance line and how much we can still use
business finance two main categories and every category have sub category so here is the logic

Sheet 2 Col G
if Sheet 1 Col A = Bank ID (Sheet 2) and Col B = Loan ID (Sheet 2) and Col C = Loan Type (Sheet2) and Col G (Loan Status) = "Not Paid" then bring the value of Col F (Loan amount)
All the col described are in sheet 1

i think i have made the logic very clear so if the bank id matches in summary and raw data it should then match the loan type and loan category and if that is not paid then bring the value of that loan into summary which can be deducted from the credit limit.

any help is highly appreciated.

Thanks In advance

Usman

here is the sample of the file, its is raw form and have to work more to bring it to a set format once have the formula in place and good understanding of the formula

hope this sheet will help

please look at the sample file and you will understand

its not in there yet that what i have to create in summary sheet the raw data is all there, i just defined the logic of the function i want to have

for Example BankID = NBF
Loan ID = TR
Loand type = Usance
if Status "not paid"
bring value of Total amount Payable from data sheet

hope you get it now

can u explain how it work like step by step calculation method, because it will help me in understanding the formula as well as make necessary changes within the formula if needed

you've made my day ive been working on this from couple of days, thank you very much.

i have learned and new thing in excel today.

Thanks Again .................!!