Retun the value of a cell above a specific pattern

[owensjb2]

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!

[NeedForExcel]

Hi,

Please see the new file attached.

On purpose I've extracted the RecordsID on B Column so that you can compare it with the original data

[owensjb2]

Thank you! That worked perfectly!

[NeedForExcel]

Glad! Please mark the thread as solved..