How do I query multiple ranges on multiple google sheet Tabs with multiple conditions?
<p>Im want to populate a spreadsheet from two other tabs in the same workbook  I believe I need a filter / query / arrayformula to do this:</p>

<p>if  Cutulator!H2:H says "save" Then lookup the Value in  column A of that row , next look for a match in  Service!B2:B and select all columns in each row with that same  value , return all  with values greater  than 0 an not blank .
thanks in advance ive been struggling with this.
Im not asking for somebody to do everything for me I would just appreciate some formula examples or advice to help me to move forward.
Jarrod</p>

<p><a href="https://docs.google.com/spreadsheets/d/1VxXsSuIyV67aKeuxiyWWo3tXqf8cyL05ZMdh8V7_dc0/edit?usp=sharing" rel="nofollow noreferrer">GSheet</a></p>