How can I make a cell reflect to the data from another? Macro or Function command?

[rob]

I did this by feeding vlookup an array, something I didn't
know I could do! <grin>

=VLOOKUP(A1,{"s",3;"w",7;"c",14;"t",21},2)

This returns a N/A if the value in A1 doesnt match the
s,w,c, or t though...

-----Original Message-----
I have a spreadsheet that has a column to represent a letter code and a
colunmn for the amount of days. How can I make the day column
automatically represent the letter code?
ei. "S= 3 days, W= 7 days, C=14 days, T= 21 days, etc." Can this be
done by a function or should this be done by a macro? And how?

Thanks in Advance!

from http://www.ExcelForum.comat http://www.ExcelTip.com/