I think VLOOKUP might work. In cell X1 try this: =VLOOKUP(B1,B$20:C$22,2,0)
Copy down as needed; Adjust 2nd parameter (B$20:C$22) as needed.
![[TEST] Document Foundation Community](https://communitytest.documentfoundation.org/images/discourse-logo-sketch.png){kind=logo}
I think VLOOKUP might work. In cell X1 try this: =VLOOKUP(B1,B$20:C$22,2,0)
Copy down as needed; Adjust 2nd parameter (B$20:C$22) as needed.