I am trying to figure out a formula where I can take 1 cell from Sheet #2,
and search for that same number on sheet number three, in the B column. I
would also like to make the two results automatically be put into words. If
found it would say On Property as of Dec., if it's not found it would say Not
on Property.

IE

I need cell B2's number which is 893210 from Sheet #2 to be searched for on
Sheet #3's B Column. If it is in Column B Sheet #3, I would like it to
display: On Property as of Dec. If it is not in Columb B Sheet #3, I would
liek it to display: Not on Property.

(when I say sheets I do not mean from one excel file to another, I am
referring to the tabbed sheets from one single excel file).

I appriciate all help on this matter as I have been fiddling with this for
what seems like days and I cannot figure it out, if it is even possible.
Thanks!