Hi Terry,

Am Mon, 08 Feb 2016 18:41:33 +0000 schrieb Terry Pinnell:

Col A Col B
----- -----
x This
y That
x This
x That
z Other
y That

It seems that the IF function has to have only two values, so cannot
be used for my purpose.

in your version you can nest a IR function 6 times.
Try:
=IF(A1="x","This",IF(A1="y","That","Other"))
or
=VLOOKUP(A1,{"x","This";"y","That";"z","Other"},2, 0)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional