You can also use the Index-Match function

Example formulaSH.xlsx