Multiple if statements in excel

I am trying to write a "multiple if statement", if such a thing exists, in a excel spreadsheet. We use this as a simple quotation database for our company.

Here is the simple if statement i have so far:

=if(l11="lost","n/a","tba")

however, l11 can = "lost", "won", "open" and "closed".

What i would like to do is for each of these statements have a different answer. E.g.
If l11=lost then display lost
if l11 = open display open
if l11 = closed display n/a

and so on...

I studied computer programming many years ago and have an ok understanding of code, if someone could reply with a suitable statement, i can edit inputs to suit.

I did think that maybe a when statement might be suitable, but this is beyond me right now.

Thanks in advance.

Sjb

Hi,

See attached how lookup works.

Bas