lookup items

[sna]

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

[snasui]

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

[sna]

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

[sna]

LN NO.
LN000010-01

[sna]

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

[sna]

Start date Term
17-Jun-22 36

[sna]

Maturity date Product Code
25-Jun-25 1016

[snasui]

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.

[sna]

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

[snasui]

Thanks for your reply. Happy new year 2023.