Extracting data from another worksheet

[Ruby12]

So I have two tabs one one is for a search criteria and the other with the raw data. I am stuck on which function to use inorder to extract data from the raw data based on multiple criteria. For example I am searching for column in the raw data but I only want the data if it meets another criteria in another column so only if it’s a no it column h return me what’s in column b.

[#2]

Provide a sample of the data you have and the result you want. Formulas are specific. Without the specifics, there is no formula to talk about.
Nonetheless, I surmise you need a lookup formula, the choice of which depends on the specifics you provide.