Formula to compare 2 columns for a given number in another column

Hi guys,

So I have a sample spreadsheet attached. Keep in mind this spreadsheet will be long so the formula can't be hard coded data. What I am looking for is this:

You have the following:

Column B - SSN
Column G - Length of Acct #
Column H - Last 2 digits of Acct #

IF for a given SSN in Column B (the normal spreadsheet will have MANY SSNs so formula needs to be dynamic), the person has a 01 in Column H and a 16 in Column B then I want the text "Review" in column E on the first row for that SSN.

In the full spreadsheet, some SSNs may have 3 rows of data and some may have 15 so the formula needs to be able to look through each row for a given SSN, then look to see if 01 and 16 are both present and then put "Review" in Column E.

Thanks for the help!

This doesn't really match your explanation in post #1 and you have not filled in any expected results (manually):

AliGW on MS365 Insider (Windows) 32 bit

	A	B	C	D	E	F	G	H
1	memnum	ssn	dob	acctnum	Review	Length of Acct#	Last 2 digits of Acct#	firstname
2	999999999	123456789	1012021	555551L0001		11	01
3	999999999	123456789	1012021	544441L0016		11	16
4	999999999	123456789	1012021	4433004447778888		16	91

Sheet: Sheet1

I've updated the original post with the spreadsheet updated to be more clear.

I just want "REVIEW" in the first row/cell in Column E corresponding to that SSN if the other conditions are met.