Two If(And statements with vlookups only returning the first value

[ab3g1nner]

=IFERROR(IF(AND('Transaction Summary Report'!G1829="ACTIVE",'Transaction Summary Report'!C1829=$B$2),VLOOKUP('Transaction Summary Report'!A1829,'LB Account Map'!A:B,2,0),IFERROR(IF(AND('Transaction Summary Report'!G1829="ACTIVE",'Transaction Summary Report'!C1829=$B$2),VLOOKUP('Transaction Summary Report'!B1829,'LB Account Map'!A:B,2,0),""),"")),"")

Need the ands, then to lookup A1829 or if in the lookup A1829 cannot be found, to lookup B1829. I've switched around A1829 to lookup in the first statement, then B1829 to look up first. Whichever lookup is in the first section of the if(and(lookup, is what is returned. Broke these up in separate parts and was able to return the proper value using the if(and(lookup to A1829, then separately B1829 and works fine. Not really familiar with other formulas other than iferror, if, and, and vlookup. Saw a post somewhere for switch, but haven't explored that yet.

 

[ab3g1nner]

I FIGURED OUT MY OWN PROBLEM!!! It was only returning the first response because both transaction types, in (A1829 & B1829) had the same label I was using to Vlookup in G1829 (ACTIVE). I modified it to where all items in column A = ACTIVE in G, and all items in column B = PP ACTIVE! Genius!!

 

[ab3g1nner]

=IFERROR(IF(AND('Transaction Summary Report'!G6000="ACTIVE",'Transaction Summary Report'!C6000=$B$2),VLOOKUP('Transaction Summary Report'!A6000,'LB Account Map'!A:B,2,0),IFERROR(IF(AND('Transaction Summary Report'!G6000="PP ACTIVE",'Transaction Summary Report'!C6000=$B$2),VLOOKUP('Transaction Summary Report'!B6000,'LB Account Map'!A:B,2,0),""),"")),"")

Therefore, this ^^ was the final working formula!

 

[Peter_SSs]

If you want, your formula ...

=IFERROR(IF(AND('Transaction Summary Report'!G6000="ACTIVE",'Transaction Summary Report'!C6000=$B$2),VLOOKUP('Transaction Summary Report'!A6000,'LB Account Map'!A:B,2,0),IFERROR(IF(AND('Transaction Summary Report'!G6000="PP ACTIVE",'Transaction Summary Report'!C6000=$B$2),VLOOKUP('Transaction Summary Report'!B6000,'LB Account Map'!A:B,2,0),""),"")),"")

... could be shortened a bit by using the LET function like this

=LET(TSR,'Transaction Summary Report'!A6000:G6000,LBAB,'LB Account Map'!A:B,IFERROR(IF(AND(INDEX(TSR,7)="ACTIVE",INDEX(TSR,3)=$B$2),VLOOKUP(INDEX(TSR,1),LBAB,2,0),IFERROR(IF(AND(INDEX(TSR,7)="PP ACTIVE",INDEX(TSR,3)=$B$2),VLOOKUP(INDEX(TSR,2),LBAB,2,0),""),"")),""))