I have some value and that value has to be found between range of data available in first two columns of excel. If the range is found, then the data available in next column has to be saved.
my value is 4.052, so this value is present in the range of below highlighted row and i need to get the value present in column C that is 36%. Some one please assist.
Hi @Anil_G , Thanks for the reply. When I tried to change the variable type, I’m getting below error. This never happened.
Hi, i got variable type as “DoubleType” but there is an error as shown below.
hi @Anil_G, after changing to system.double, I’m getting same error.
Please add like this
percentvar = CDBL(Dt.AsEnumerable.Where(function(x) valuevar>Cint(x(0)) And Cint(x(1)) > valuevar)(0)(3).ToString)