I have a data set with Identifiers in column A, a second column containing identifiers in column B and a value in column C.
I want to find all records in column B that has the same identifier as column A, and THEN check the value in column C for each record until I find a value of x. Therefore, I want the formula to stop looking when it finds the value I'm looking for and return TRUE (or false) in column D.
In this example, I want to find the value = 0 in column C. Hence, the formula for row 1 should return TRUE since I found a value of 0 on row 3 where A was found in column B.
A B C D
1 N4 N5 1 TRUE
2 N8 N4 1 FALSE (Because it can't find A in column B)
3 N6 N4 0 FALSE (Because it can't find A in column B)
4 N7 N4 1 FALSE (Because it can't find A in column B)
Any thoughts ?
Open in new windowand copy it down.