The following VB.Net source code using Microsoft Excel 12.0 Object Library for reading an Excel file. Also this program explains how to Find the last used row in Excel and how to find Named Ranges in Excel.
I am trying to loop until the last non-empty row and check A, B, C columns for matching data and then give out the corresponding 4th column as output.
