Formula please to put a word in the left Cell ( "Roster" )
 

Hello from Steved

Cell D:6 Cell E:6
Roster Roskill

I have a City called Roskill in Cell E:6 What formula would I use please to
put the word Roster in Cell D:6 I have several hundred to do.

Thankyou.

Formula please to put a word in the left Cell ( "Roster" )
 

More information needed.

Why Roster? What are your criteria? Is this a table of information? Or do
you only want Roster to appear is Roskill is in column e??
=IF(E6="Roskill","Roster","")

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Steved" wrote:

Hello from Steved

Cell D:6 Cell E:6
Roster Roskill

I have a City called Roskill in Cell E:6 What formula would I use please to
put the word Roster in Cell D:6 I have several hundred to do.

Thankyou.

Formula please to put a word in the left Cell ( "Roster" )
 

Hello Luke from Steved

Firstly all the best for 2009

In coulmn E:E I have 7 different Cities They Are
"City", "Roskill", "Wiri", "Swanson", "Panmure", "Shore", "Orewa".

"Luke M" wrote:

More information needed.

Why Roster? What are your criteria? Is this a table of information? Or do
you only want Roster to appear is Roskill is in column e??
=IF(E6="Roskill","Roster","")

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Steved" wrote:

Hello from Steved

Cell D:6 Cell E:6
Roster Roskill

I have a City called Roskill in Cell E:6 What formula would I use please to
put the word Roster in Cell D:6 I have several hundred to do.

Thankyou.

Formula please to put a word in the left Cell ( "Roster" )
 

And do you have 7 different results to enter in column D? If so, you could
use either nested IFs or a VLOOKUP.

If any of those in column E give the same in column D, use the OR function.
--
David Biddulph

"Steved" wrote in message
...
Hello Luke from Steved

Firstly all the best for 2009

In coulmn E:E I have 7 different Cities They Are
"City", "Roskill", "Wiri", "Swanson", "Panmure", "Shore", "Orewa".

"Luke M" wrote:

More information needed.

Why Roster? What are your criteria? Is this a table of information? Or do
you only want Roster to appear is Roskill is in column e??
=IF(E6="Roskill","Roster","")

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Steved" wrote:

Hello from Steved

Cell D:6 Cell E:6
Roster Roskill

I have a City called Roskill in Cell E:6 What formula would I use
please to
put the word Roster in Cell D:6 I have several hundred to do.

Thankyou.