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

[Steved]

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.

 

[Luke M]

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","")

 

[Steved]

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".

 

[David Biddulph]

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.