I was having issues with Vlookup functionality in a 2 column array. It does
not recognize the value I have in the array intil I over type the value and
then the vlookup functionality works.

My equation looks like this: =VLOOKUP(A2,$J$2:$K$5815,2,FALSE)