Hello

I am trying to find or match a value from one sheet in another sheet.
So for example

The formula would look at the value in cell A1 Sheet 1 and look for the
value in $A$1:$A$50 Sheet 2. If it finds it, then it would return a
value of true, OR it would return the value in cell C1 from Sheet 1.

The problem I have been facing is that if I were to use the Vlookup
function, I would not be able to retun the value of c1 from sheet one,
it only returns the value where the table array is (which in this case
is Sheet 2!!)

Anybody have any ideas on how I can do this?

Thanks

Cory