Reduce two formula commas into one

[beginvbaanalyst]

Hi Everyone,

I'd like to turn an iferror index match formula for one column and a if(change(vlookup in my second column, into just one column.
How would I go about do this?
My formulas are:
This works for finding out new loans by index matching the type to with the current Join concatenate

=IFERROR(INDEX(Table2[Type],MATCH([@[Join 2]],Table2[Join2],0)),"New")

This works by utilizing the index match to compare and bring over the old balance.

=IFERROR(IF([@[Change V2]]<>[@Type],VLOOKUP([@[Join 2]],'Jan23'!F:J,5,0),"-"),"New")

If data is needed I will provide what I'm doing.

 

[Fluff]

Maybe

=IFERROR(IF(INDEX(Table2[Type],MATCH([@[Join 2]],Table2[Join2],0))<>[@Type],VLOOKUP([@[Join 2]],'Jan23'!F:J,5,0),"-"),"New")

 

[beginvbaanalyst]

Maybe

=IFERROR(IF(INDEX(Table2[Type],MATCH([@[Join 2]],Table2[Join2],0))<>[@Type],VLOOKUP([@[Join 2]],'Jan23'!F:J,5,0),"-"),"New")

Worked like a charm! Had to adjust the lookup array but understood what you were doing.

New question for you, I'm trying to sum the prior month balance of all loan ID that are no longer in my current month as it was paid off. I can use this formula but adjust some values right? For some reason I get it to lookup all balances.

=IFERROR(IF(INDEX(Table2[Balance],MATCH(Table2[@[Loan ID]],[Loan ID],0))<>Table2[Loan ID],VLOOKUP(Table2[@[Loan ID]],'Jan23'!C:I,7,0),"-"),"-")

^Current formula that pulls all balance.
Basically in my head I have if the Jan23 (table 2) loan id doesn't match my current month (Feb23) loan ID, lookup balance of past loan ID to return balance of past loan id. I just specifically want to return the Jan23 (table 2) loan balance if it's no longer in the Feb23 (table 1). I think it's pulling the loan ID balance from all existing loan ids from Feb 23 if it was still in Jan23

 

[Fluff]

Glad to help & thanks for the feedback.
Please start a new thread for your new question.