If then or, maybe vlookup or index

[BrutalLogiC]

Hello hope you can help

I have a column O with 7 different codes, each one relates to a name.

I just want to a formula to look at the code in O then return the name.

B2:B8 are the list of codes
C2:C8 are the list of names

I want a formula in A11 which looks at the code in O11 then returns the name based on the table in B2:C8

Hopefully that makes sense

 

[Peter_SSs]

Try
=VLOOKUP(O11,$B$2:$C$8,2,0)