VLOOKUP - 1 Column Table

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