Hello everyone,

I'm really bad with formulas but I am sure this is possible. I hope this is
possible

I need a formula that will look at a text value in any given cell, A2 of
Sheet 2 for example, and search and tell me if that same text value appears
in ANY row of Column B on sheet 1, and if so return a 1(yes) or 2(no) type
result,

Is this possible? Looking around it seems like VLOOKUP coul be used to do
what I need but I don't follow the logic required.

Any help greatly appreciated