Snasui Excel Forum

hi there

i need your help how write formula in M365 to get data from List of active loan base on criteria in column K meets loan product code 1016,1018

i need results to come up in sheet Recalculation FV Staff loans-22 in color cells

tks

Please provide some example values and explain where the source and condition of it for other member easy to understand.

Hi Admin
I want to get values from list of active loan to Recalculation FV Staff loans-22 if loan product code is 1016,1018 to the color cells .I give an example of data got from list of active loan if loan product code is 1016 or 1018.

Thanks

LN NO.
LN000010-01

Loan disbursement Bal O/S AIR
3,000.00 2,502.00 17.1257

Start date Term
17-Jun-22 36

Maturity date Product Code
25-Jun-25 1016

Try this formula in cell D6,

=FILTER('List of Active Loan'!B$11:B$151,ISNUMBER(MATCH('List of Active Loan'!$K$11:$K$151,{1016;1018},0)))

Press Enter > Copy this formula to the remaining columns and change B$11:B$151 to the range that you would like to get the result.

Wow ,thank you so much.happy new year coming soon .wish you good luck and happiness.
Best regards,

Thanks for your reply. Happy new year 2023.