Find and Return a Value

[gplush]

I have a list of values in one column, say they are ABCD. I want to look at a master column that says A=1, B=2, C=3, D=4. I want to return the value of ABCD to a new column. It would look like this..

A 1. If (A1=A, 1)...
B 2
C 3
D 4

I know how to do it with an if statement, but it would really nested if I did that. Is there an easy way.

[NBVC]

You could use Vlookup... have a look at this function in Excel Help files