Pull data from one sheet to another with 2 criteria

[Cyndi2210]

I have a query with several sheets that I am trying to pull into the data sheet. I need the 401L2 Loan Amount from the "Loans" sheet to populate the Loan Payment 2 column in the Data sheet. The 401L needs to populate the Loan Payment 1 column.

 

[Joe4]

Formula for Loan Payment 1:

=SUMIFS(Loans[Loan Amount],Loans[Employee'#],[@[Employee'#]],Loans[Type],"401L")

Formula for Loan Payment 2:

=SUMIFS(Loans[Loan Amount],Loans[Employee'#],[@[Employee'#]],Loans[Type],"401L2")

 

[Cyndi2210]

Thank you so much. It works, however I forgot to mention that I need the zero transactions to be blank.

 

[Joe4]

Thank you so much. It works, however I forgot to mention that I need the zero transactions to be blank.

Why not just hide the zeroes values with a custom cell format, as described here?

Display or hide zero values - Microsoft Support

Hide or display zero values in Excel worksheets by using an option in the Advanced tab, or by using a number format, using a conditional format, a function, and by hiding zeros in PivotTable reports.

support.microsoft.com

 

[Cyndi2210]

Perfect. I do these queries about once every 6-9 months, so I forget these things in between each one.

 

[Joe4]

No worries!
Glad I was able to help.