My problem is that I am trying to take a number in 1 cell from one sheet and
search a whole column on another sheet.

I also need it to be able to continue to search the same column on the other
sheet even if I select a new cell.

I cannot remember how to do this effectively but it would save so much time
compared to using the find method and switiching from sheet to sheet. Please
help!