Expand a code using a formula in Excel

Hi All,

I require a formula to assist with returning results from a code.

Basically I will have numerous codes being developed based on particular outcomes and I want to be able to utilise a formula to tell me what that code actually means.

e.g.
S = Successful
0 = 1
1 = 2
2 = 3
3 = 4
UNK = UNK

S0133UNK = Succesful1244UNK
S0123UNK = Succesful1344UNK
S0212UNK = Succesful1323UNK

if I get an outcome equal to 'S0133UNK', I want 'Succesful1244UNK' to return.

Is there something I can use? The variables I may have is extensive and i'd like to be able to put in the details and have an outcome return.

Hi,

This is Firm & Fix for the data provided in your example.

The same can be finalized only after answering Question "POST 2" FDibbins.

Punnam

Hi Punnam. This almost got me there. Is there anyway to apply this to multiply lists and combine into one result? It looks like I have some codes coming through with values that are the same but equal something different so i'll need different tables to house the data?

e.g.
one table
1 = S
2 = NS
3 = SP

another table
0 = NP
1 = PPE
2 = NPPE etc.

any ideas?