check value in cell

[Marin]

hello all,

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)

Thank you in advance for your help

 

[Claus Busch]

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

 

[Marin]

Hi Marin,



Am Fri, 22 Feb 2013 10:39:41 -0800 (PST) schrieb Marin:






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

thank you very much Claus
IF command works perfectly
thanks again, you have helped me a lot