I have 2 columns of account numbers and all I'm trying to do is identify
which accounts in Column A are also in Column B.

The formula I'm using is vlookup(A2,B:B,1,False) and I keep receiving the
#N/A stating "A value is not available to the formula or function."

Column A has the ' at the beginning of the account numbers, I believe in
order to prevent the 17 digit number from being concatenated. There are
approx. 42k numbers/cells.
Column B has the 17 digit numbers as well but no '. The numbers do appear to
have some extra spaces at the end of the cell for some reason. There are
approx. 5k numbers/cells

I did sort Column B (the table array) in ascending order.

I don't know if the formatting, ', or spaces is affecting the formula. When
I use True instead of False, I do get a result but its wrong.