Excel Help

[Albo]

Column A has different codes in it. I want to output a certain letter in column B depending on what the code in A is (some codes will output the same letter)

Could someone assist? It doesn't seem to like my IF statement.

Thanks

 

[Albo]

For some reason it now does like my IF statement (don't know what i've done differently)

Problem is I want to say IF cell1 = "code" then output "A" else do nothing (fine).

But then I want to go on to say IF cell1 = "code2" then output "B" else do notning. Trouble is the "do nothing command of line 1 is conflicting with the "output B" command of line 2.

 

[Albo]

Solved it - I tried a nested if statement but it will only allow 8 IF's. Solved it by creating a table and using VLOOKUP.

Thanks for all your help.