How to use the VLOOKUP function using NPOI c# ?

may this be helpful, sample.

usingNPOI.HSSF.UserModel;
usingNPOI.SS.UserModel;
//.....
privatevoidbutton1_Click(objectsender,EventArgse)
{
HSSFWorkbookhssfwb;
using(FileStreamfile=newFileStream(@"c:\test.xls",FileMode.Open,FileAccess.Read))
{
hssfwb=newHSSFWorkbook(file);
}
ISheetsheet=hssfwb.GetSheet("Arkusz1");
for(introw=0;row<=sheet.LastRowNum;row++)
{
if(sheet.GetRow(row)!=null)//nulliswhentherowonlycontainsemptycells
{
MessageBox.Show(string.Format("Row{0}={1}",row,sheet.GetRow(row).GetCell(0).StringCellValue));
}
}
}

Mark as answer, if helpful.