Lookup two column and get the value of next column

Hi,

I have two excel sheet.

The first sheet view is:

image

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

image

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