Switch(case) statement(enhanced if statement)

Hello,

Does MS Excel have an enhanced, multiple choice, IF statement such as those found in most high level programming languages(such as C and Pascal), under names such as case, or switch statements?

Here is what i need to do: I have to complete a table that containt the name and ID of a data transmission circuit, there is a one to one corespondence between the name and the ID, so I would like the name cell to be completed automatically after i fill in the ID cell.

One obvious way to do this would be to create the mother of all nested if statements, but this has two problems. First of all, it's a lot of work and I am lazy, and second of all, it scales awfully and should i need to add another circuit, this would need the rethinking of the nested if.

Obviously, i would be satisfied if anyone could give me another suggestion to solve this problem.

Thank you,

Paul

Try Vlookup. Syntax is =Vlookup(lookup value,range,column,0 or 1). The 0 is if you want an exact match, which you would in your case, and the 1 finds the closest match without going over.

WOW, you guys sure move fast, the thread is barely half an hour old and already i got two responses.

Thanks a lot to both, i think i'm going to go with the VLOOKUP solution, because i really don't know how to define my own functions and that seems enough for what I need right now.

I was heading for the nested if solution(not very elegant but at least it would work), or so i thought, but i found out that at the seventh or eighth nesting level i got an error. I'm pretty sure it wasn't a typo, or any other mistake on my side because i tried rewriting quite a few times.

Do you by any chance know if there is a limit to how deep this sort of nesting can go, and if it's near the value of 7?

Originally Posted by shg

In versions of Excel other than 2007, the limit is indeed 7.

yep, i know, i found out for myself. turns out i should have rtfm.

great forum anyways,

thanks a million