View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Seraslynz Seraslynz is offline
external usenet poster
 
Posts: 3
Default Creating Function to Reference Cells that Contain Certain Values

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.