Countifs and Vlookup Formula Help

[Fanwood]

I am trying to combine a vlookup and a countifs but no success

=COUNTIFS('BAC-HELOC'!E:E,VLOOKUP('BAC-HELOC'!E:E,P:Q,2,FALSE)="MN",'BAC-HELOC'!J:J,"L")

Maybe I am not writing it correctly.

I am using the vlookup on a key that takes a bunch of different data and groups them

So if E:E Finds a match in the vlookup conversion and J:J has L count it.

Does any of my explanation make sense?

 

[steve the fish]

Im not quite understanding the need for vlookup? Does this work?

=COUNTIFS(Q:Q,"MN",'BAC-HELOC'!J:J,"L")