Assume your B C or V values are in cell A2, the following formula will
give you what you want;

=IF(A2="B","Consumer",IF(A2="C","Real Estate","Visa"))

This assumes that only the values B C or V can exist in A2.

You probably got the ?NAME error by omitting the "" around the B etc,
so Excel was looking for a named range.

Pete