check value in cell
 

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

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

check value in cell
 

On Friday, February 22, 2013 7:50:42 PM UTC+1, Claus Busch wrote:
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


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