running MATCH formula from NPOI help

Nov 1, 2016 at 8:45 PM
Good day, below is some code that I am trying to run. I realized my issue only happens when I have a 0 in for match but if I change it to 1 or -1 it works. It doesnt seem to be reconizing the 0, how do I fix this?

I tried another route by taking my data and moving it to the right hand of what I need and using a vlookup but the VLookup
sheet1.CreateRow(row + firstrow).CreateCell(19).SetCellFormula("VLOOKUP(" + j + "," + lookuprangess + "," + 2 + "," + "FALSE" + ")");  
gives the error
((NPOI.HSSF.UserModel.HSSFSheet)sheet1).IsAutoTabColor '((NPOI.HSSF.UserModel.HSSFSheet)sheet1).IsAutoTabColor' threw an exception of type 'System.NullReferenceException'
for (int row = 1; row <= 4; row++)
{
sheet1.CreateRow(row + firstrow + 1).CreateCell(15).SetCellFormula("LARGE(" + cellsranges + "," + row + ")");
HSSFFormulaEvaluator.EvaluateAllFormulaCells(hssfwb);

double j = sheet1.GetRow(row + firstrow + 1).GetCell(15).NumericCellValue;

sheet1.CreateRow(row + firstrow + 1).CreateCell(16).SetCellFormula("MATCH(" + j + "," + cellsranges + ", " + 0 + ")");
HSSFFormulaEvaluator.EvaluateAllFormulaCells(hssfwb);

double k = sheet1.GetRow(row + firstrow + 1).GetCell(16).NumericCellValue;

sheet1.CreateRow(row + firstrow + 1).CreateCell(17).SetCellFormula("INDEX(" + statesranges + "," + k + "," + 1 + ")");
HSSFFormulaEvaluator.EvaluateAllFormulaCells(hssfwb);

string stateperc = sheet1.GetRow(row + firstrow+1).GetCell(17).StringCellValue + "-" + j.ToString();

MessageBox.Show(stateperc);
}
I am new to this so sorry if it is simple!