Steven-
I *think* you need a VLOOKUP() formula, but I'm not sure. VLOOKUP will
return the value in another cell when it matches the parameters you
provide. Take a look at VLOOKUP in the Help feature, or post more
information.

Good luck!