Extract data using two variables or criteria

Hello,

I am in need of assistance, I am trying to make some case management work more efficient and streamlined that when someone copy and pastes info to an excel spreadsheet it pulls the info from that sheet into the rest of the workbook. I was able to extract all info that was static, cells don't change position. However, the problem comes where there is range of cells to lookup and extract information using given criteria. I made sample spreadsheet (see attached.) What I need pulled from the list the head of the household and their info and other parents info. So rows 1-10 will contain family data, everybody that is associated with that household or was associated in the past. With columns B-H containing info.

What I would like for Excel to do is to look at the column G G2:G10 find code 0 (head of household) then check the status code in column H and if it is A,B,C or D pull relevant info in row 18 B-F. If it is any other code leave it blank and don't pull.
I am pretty sure I am supposed to use VLOOKUP, MATCH and IF function with OR AND I just don't know how to put all together.

However, it does not stop there it get's a bit more trickier to extract info for other parent Row 19 B-F. For that data extraction I need Excel to look at the column G G2:G10 look for either code 1 or P and pull data for that row that contains either 1 or P with code of A,B,C or D. Luckily they are mutually exclusive so only one of them will have the right coding. Meaning there will never be a situation where a 1 and a P have same status code. So if one code has A,B,C or D the other one will I, M, N or S next to it.

Can this be done? It would save a lot of data entry time for me. I appreciate any help or advice you can give me. Tnx.Family Data.xlsx

So I assume this is not possible by the lack of suggestions or answers.