Hello,

I am needing help creating a formula that will search if column A of sheet 1 values exist in sheet 2's entire column A range. If it exists, output a "Yes" in corresponding sheet 1 column B next to the searched value. Otherwise output a "No". I have searched for days trying to find the perfect formula for this. Seemed simple at first however, the difficult part is the formula must look for values that are case sensitive, exact, and allows for a mix of numbers and text in the search.

Example:

Sheet 1
Column A
Test1
test1
Te1st
te1st

Sheet 2
Column A
Test1abc
ABCTest1
Te1st
t1est

The desired result would output "Yes" for Te1st. "No" for the others.