Copying a cell value to another sheet by using If statement

[naga rajan]

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

 

[Claus Busch]

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