sos question in excel

emmapapa2 

=VLOOKUP(H1,D2:E13,2,FALSE)

=INDEX(D2:E13,MATCH(H1,D2:D13,0),2)

Is this what you are looking for?

If you work with Office365 or 2021 you can use XLOOKUP as well.