Retun the value of a cell above a specific pattern

Hi all,

I was helped in the past with the script below, but I am having trouble altering it to work for another task. Essentially I want everytime strings with the phrase, "positive Match" and "2_Not List" appear in consecutive cells, I want to return the Record ID.

For the sample data attached the results would end up in A1 of the same sheet as

123456789
01234567

Please Login or Register  to view this content.

Thank you in advance!

Thank you! That worked perfectly!