How to find the matching or nearest value from specified excel range using C#

[Gani tpt]

How to find the matching value from specified excel range using C#

I have the excel table which contains some values.

I want to get matching value or nearest value in the specified cell range

For below screen shot example,

I have the data from the range D6:I6 and D10:I10.

In the above range, i want to find and get the matching or nearest value and its column name.

If i pass the Input parameter value ==> 550

output :
then nearest value in the cell range(D6:I6 and D10:I10) is : 540
column is : H




Continue reading...