Hi I am searching through 2 uneven columns, column A with ~1500 rows
and column B with ~250 rows.

Column A is obviously much more inclusive, but I need to know if an
entry in column B appears anywhere in column A. I'm looking for a
function/macro that can be written-and-edited to search for an entry in
both column A and B.

ctrl+f is painful and an IF function is not practical with 250 rows,
let alone editing it and pasting down 1500 rows each time it is edited.

Any help is greatly appreciated!

B