I need to know if there is a way that when an if statement is either true or
false the value returned can contain a mixture of text and a cell reference.
Example =IF(A12=4,"Mdl =" cell reference here, value if false)