View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default 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.