Formula for column 3
=IF(B2="", " ", "=")
Formula for Column 4
=IF(ISBLANK(B2), "<---Enter Data to Find", IFERROR(VLOOKUP(B2,A:A,1,FALSE),"Not in the list"))
Column1 is Paste Data
Column2 is Items to find
Column3 is = sign
Column4 is Results