I really am rusty! Could someone please remind me how to enter a
function in col B that will return different strings depending on the
content of col A. Like this:

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.

If it matters, I'm still using my ancient Excel 2000.



--
Terry, East Grinstead, UK