One way:

=IF(A1="B","consumer",IF(A1="C","real estate",
IF(A1="V","Visa","Other")))


In article ,
"Karen" wrote:

I am not sure if this is possible. I would like to return a value of
"consumer," "real estate", or "Visa" dependant on if another cell is equal to
B, C, or V. I get the error message ?NAME... so I am not sure if this is the
right formula - because the IF/Then needs numberical data or if it is
possible! Any ideas?