check value in cell
Hi Marin,
Am Fri, 22 Feb 2013 10:39:41 -0800 (PST) schrieb Marin:
if in cell a1 is (cat) then in cell B1 should be (miau), if the a1 (dog) then b1 (wow), and if a1 (cow) then the b2 (mu)
try:
=VLOOKUP(A1;{"cat"."miau";"dog"."wow";"cow"."mu"}; 2;0)
or:
=IF(A1="cat";"miau";IF(A1="dog";"wow";IF(A1="cow"; "mu";"")))
and change the delimiter if the formulas don't work for your language
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|