Formula in B2

=VLOOKUP(DROP(TOCOL(A:A,1),1),D:E,2,0)

Formula in B2

=VLOOKUP(DROP(TOCOL(A:A,1),1),D:E,2,0)

Explanation

1. VLOOKUP provides the basic functionality:

   VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
   

2. The lookup_value is DROP(TOCOL(A:A,1),1)
   • TOCOL returns Column A without any blank rows.
   • The DROP function is used to remove the heading row Name from the lookup_value.
3. The table_array is D:E
4. The col_index_num to return is 2 which is Column E.
5. The 0 (FALSE) specifies an exact match in case D:E is not sorted in ascsending order.