| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying a cell value to another sheet by using If statement
Hello everyone,
Am having the following example. A1=john or james or raja B1= salary If A1="john" then B1 should be copied to B1 of sheet 2 If A1="james" then B1 should be copied to C1 of sheet 2 How to achieve this? Please help Thanks, Naga |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying a cell value to another sheet by using If statement
Hi Naga,
Am Tue, 25 Dec 2012 02:15:29 -0800 (PST) schrieb naga rajan: A1=john or james or raja B1= salary If A1="john" then B1 should be copied to B1 of sheet 2 If A1="james" then B1 should be copied to C1 of sheet 2 in B1 of sheet2: =IF(Sheet1!A1="john",Sheet1!A2,"") in C1 of sheet2: =IF(Sheet1!A1="james",Sheet1!A2,"") Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copying data from a cell on sheet to a diff cell/sheet | Excel Worksheet Functions | |||
| copying cell comment from one sheet to another | Excel Programming | |||
| Copying values from one sheet to the same cell in another sheet | Excel Discussion (Misc queries) | |||
| How to use cell fron different sheet in IF statement | Excel Discussion (Misc queries) | |||
| If Statement and copying all of cell contents. | Excel Worksheet Functions | |||
Linear Mode
