Help to get third value

[repinsa]

Hello,

Am having this excel where i want to find out if Column A contain text from Column b so it can return its value from column C.
Can you please help?

Thanks

[PaulM100]

Try: =ifferror(vlookup(a2,$b:$D,4,0),"")

[repinsa]

it didn't work

[PaulM100]

Change 4 with 3, and check this out: https://www.xelplus.com/basics-vlookup-hlookup/

[repinsa]

Thank you!