Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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;) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check or uncheck a check box based on a cell value | Excel Discussion (Misc queries) | |||
Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
Cannot check the check mark box in cell | Excel Worksheet Functions | |||
check to see if a cell is blank if not populate adjacent cell wit. | Excel Discussion (Misc queries) | |||
Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions |