Find text and display value relative to that text

Hey guys,

This is my first thread on this forum and, besides the basic IF, AND, and OR functions, I'm not very good at using Excel.
Let's say that I have one column full of letters and another full of numbers (respectively): so if I have A in one cell, I have 1 directly next to it to the right. If I have B in one cell, I have 2 directly next to it to the right etc.

I would like a function that would allow me to search a specific range for a specific value and return the value to the right (or the left) of that cell. For instance: if I'm looking for C, it would return 3 (since it's the one directly to the left).

Any ideas of how to do that?
Thanks in advance.

Hi, welcome to the forum

Maybe something like this, using VLOOKUP...

	A	B	C	D
2	a	1	a	1
3	b	2
4	c	3
5	d	4
6	e	5

C2=what you want find
D2=VLOOKUP(C2,$A$2:$B$6,2,0)

Happy to help