Lookup two column and get the value of next column


I have two excel sheet.

The first sheet view is:


If the last column contain the highlighted code then i would like it to map with another sheet which is:


I want to grab the value from column category.

Is there any idea to done this?

Thanks so much!!!

Keep the reference values from Excel1.
ForEachRow for Excel2
Compare Row(0).toString value to “Code” value,Row(2).ToString value to “CT Code” value. If found, rab the value from Row(3).toString