| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change text on one cell based on text in another
I have a worksheet that states "Welcome Reception" in cell E, rows 7, 10, 17,
etc. I need to change cell F, same rows, to say "Akimel 3". Is there a formula that can do that? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change text on one cell based on text in another
i'd use a vlookup
=vlookup(e7,ltable,2) ltable is named range 1 2 a Welcome reception akimel 3 b welcome primary jossle 2 You question is a little vague, but i hope this helps "Sally B." wrote: I have a worksheet that states "Welcome Reception" in cell E, rows 7, 10, 17, etc. I need to change cell F, same rows, to say "Akimel 3". Is there a formula that can do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Limitations ? Formatting and Size when exporting to Tab based Text file? | Excel Worksheet Functions | |||
| Cell text based on 4 condition test | Excel Worksheet Functions | |||
| Change cell color based on contents | Excel Discussion (Misc queries) | |||
| Change colour of Text if number in cell exceed limit | Excel Worksheet Functions | |||
| change text color based on logical test | Excel Worksheet Functions | |||
Linear Mode
