VLOOKUP Returning #VALUE! Error When Using Same Formula In Different Cells

[sploeger0709]

I'm using the VLOOKUP function to pull info from a database and I'm getting a #VALUE! error in 2 cells. The same formula is used in about 60 other cells pulling info from different columns in the database and it is returning the correct information. The only difference in these 2 cells is the column index indicator, so I cannot figure out why these specific cells are not working. I even have cells that have this formula embedded with other nested formulas and it still works properly.

This is the formula from one of the cells that is functioning properly:
=IF($B$1="","",VLOOKUP($B$1,'Result Database'!A:BM,8,'Result Database'!A:BM))

This is the formula from one of the 2 cells that is returning the #VALUE! error:
=IF($B$1="","",VLOOKUP($B$1,'Result Database'!A:BM,2,'Result Database'!A:BM))

The cells in both locations are formated as "General", so there shouldn't be any formatting incompatibilities.
I can't for the life of me figure out why these 2 cells aren't working!