Hi guys

I am having some issues trying to embed two formulas together or not sure where to begin.

I have a list of account numbers that the dollar amount they have sold. That portion is pretty simple, however, one account number is listed multiple times under different headings by "dollar type" eg. coop or VB or new launch.

Now, I am only interested in getting the dollar amount that is listed as coop, as an example.

I tried this formula that I saw online but not sure how to make it work with my formula

=IF(ISERR(SEARCH(W$9,'RB1'!J6)),"",VLOOKUP($D10,'RB1'!$E$6:$CR$1719,58))

RB1 = sheet that contains "dollar type" and "sold amount".
W9 = header that shows "coop"


Any idea on how I can achieve this? thanks so much!