Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel 2007 on WinXP
I need to evaluate the contents of Column F. If the cell contaions the word "Lead", place Lead in column G If the cell contains the word "Manager". place Manager in column G If the cell contains the word "Supervisor", place Super in column G I used the formula below. =IF(FIND("Lead", F3)0, "Lead", IF(FIND("Manager", F3)0, "manager", IF(FIND("Supervisor", F3)0, "Super", "standard"))) Only those rows that contain "Lead: somewhere in in column F record Lead in column G, all others report VALUE#. Can someone point me toward my error. It is important for you to know that cells in column F wil have more than just the word Lead, Manager or Supervisor; these words may be at beginning, in middle or at the end. They will always be separate words. Thanks for any suggestions |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
4 if's, with 4 different results | Excel Worksheet Functions | |||
Multiple IF's to Select a Value | Excel Worksheet Functions | |||
Multiple If's and OR's | Excel Worksheet Functions | |||
multiple IF's ? | Excel Worksheet Functions | |||
Formula with multiple IF'S | Excel Discussion (Misc queries) |