Dec 09 2021 02:54 PM
=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.
Dec 09 2021 03:00 PM
Please stop asking every question multiple times!