Many thks for yr interest, hope this will shed more light on what i am trying to achieve.
By entering a value in cell a1, for example "ATL" then i want to display in cell b1 the full name of the entered abbreviation i.e. "Atlanta"
When you use the IF, Else Formulae statements this is a breeze as IF,Else statements can display/return either a numerical value/calculation or text (as in my requirement, but this string is limited to seven enclosed if,else statements
My situation calls for (14) fourteen different abbreviations that need to return a full name, so I cannot use the if,else method
another way of doing this allowing up to 250 scenarios is showed/explained in the below example
instead of the standard if,else which will look like this =If(A1="a",1,If(A1="b",2,if(A1="c",3,if .... will only allow (7) seven ifs in one string,
but this method =(A1="a")*(1)+(A1="b")*(2)+(A1="c")*(3)+(A1="d")*(4) where "="represents the same as "if" and the"*"represents "then" if true or the "+" represents "else" ....
caters for a total of 250 statements in one string. However my problem is that instead of displaying/returning a numerical number ... 1,2,3,4, as shown, i need to display/return text or a name like this ... =(A1="atl")*(Atlanta)+(A1="lhr")*(Heathrow)+ ..... but the statement display/return a ... #VALUE! error because of the text"atlanta"
Can i, and how, do i get this to work