In Visual Basic/VB.net, in the Visual Studio IDE, write a program that can copy one column of data from an excel (.csv) file, to another excel (.csv) file. But there is a more complex detail. I have included pictures to explain the problem. Please read carefully. In the second picture with many columns of data, see column i. Column i has values that were all hard-coded into my program. These values are dependent on column C. For example, at 380 for column C, the values for column i are 59.37. I have hard-coded many lines of data with a bunch of IF ELSEIF statements. This method is very inefficient. I want to be able to include the other excel (.csv) file seen in the first picture so that I do not have to hard-code the values for column i. I want my program to automatically put the proper numbers in column i, from another excel (.csv) file, and they should be the correct numbers based on column C. Also consider that the data for the second picture starts at row 9, and data for the first picture starts at row 2. I will give a positive rating for a good solution. Thank you.

1 Signal FreqAtten Offset 25 58.89 57.37 56.02 54.88 53.86 52.95 52.13 51.4 50.74 50.1 49.53 48.99 48.48 48.01 47.56 47.15 46.74 46.38 46.02 45.69 45.36 45.06 4 35 45 10 12 13 75 16 17 18 19 95 100 105 110 115 21 125 23 130 1 Signal FreqAtten Offset 25 58.89 57.37 56.02 54.88 53.86 52.95 52.13 51.4 50.74 50.1 49.53 48.99 48.48 48.01 47.56 47.15 46.74 46.38 46.02 45.69 45.36 45.06 4 35 45 10 12 13 75 16 17 18 19 95 100 105 110 115 21 125 23 130