Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want to insert a function, I assume an "IF" function that gives me back
different values depending on if the referenced cells contain certain information. For example: A2: FS2-670-SB If A2 contains the letters "SB" then the function with return "SMBS" I want to do multiple IF functions so that depending on the "key" letters, the function will return a certain answer So, If the cell contains "SB" then return "SMBS", if cell contains "SMB" cell returns "SMBS", if cell contains "SS" then return "SHIN", if cell contains "BB" then cell returns "BBUL" etc. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating a Unique Reference from 2 cells | Excel Discussion (Misc queries) | |||
Creating a reference from one cell to several other relavent cells | Excel Discussion (Misc queries) | |||
INDIRECT function to reference values in another worksheet | Excel Worksheet Functions | |||
creating a range reference from cell values | Excel Discussion (Misc queries) | |||
Creating a Pivot Table to reference values | Excel Worksheet Functions |