Suppose you have a list of data like:

Col A Col B
Smith Yes
Thomas No
Wilson Yes
Johnson No
Fox No
Stride Yes
Gall Yes
Lackett Yes
Shope No
Robinson Yes

I want to lookup column B and find all instances of "No" and return corresponding value from column A, so the output would look like:

Thomas
Johnson
Fox
Shope