If anyone can help it would be greatly appreciated.

I am trying to set up a formula for excel to look at a letter for a
specific number.
It is actually a rate sheet but each rate has a number associated with
it, A equals 209, b equals 179. I want excel to look at that number and
return a letter code that corresponds to it. If it would be easier I
have table for excel to reference. It basically states the alpha is in
a row and the number is in a corresponding row. I was trying to make is
do something along the lines of this:
If A5=
=IF(C5='worksheet 1 '!A5, then display the number in 'worksheet1 '!C5)

If anyone can help is would be greatly appreciated.
Thanks


--
Stonicus
------------------------------------------------------------------------
Stonicus's Profile: http://www.excelforum.com/member.php...o&userid=16383
View this thread: http://www.excelforum.com/showthread...hreadid=277561