Select a 1: D4, formula-user-defined name-created according to the selection, check "first row" and "leftmost column", and then confirm.

Input: Zhang San of A2 cell in Table No.2? Math, get Zhang San's math score. Note: There must be a space between Zhang San and mathematics, and so on.