Question Import a data from excel related column

[Engineerist]

Hi Everybody,


There is an excel workbook, and it has 6 columns. First columns shows diameters of Tank. I am trying to select "Dp" (3th Column) and "h2" (4th Column) according to the 1st column. Just like excel VLOOKUP function.


Here is the excel workbook.


https://hotfile.com/dl/241244375/8cd21af/Tank.xlsx.html


If you can assign the value of 3nd and 4nd columns according to 1st column to an inputbox or a textbox, you are great


Thanks in Advance