Use the choose worksheet function.

--
Regards,
Tom Ogilvy


"filo666" wrote in message
...
Hi, I'm sick and tired always having to use VB when a Case structure is
need,
how could I create a case structure; I want to appears like this:

"=case(a1=b1;ab1;a1=b2;c1;a1=b3;ab3;a1=b4;b1.. .)" or
"=case(a1=b1;a1=b2;ab1;c1...)"

In English: When a1=b1 print ab1, when a1=b2 print c1 and so on.

So, how could I create my own case function?
PD. I know "=if" allow 9 condition, I don't want use =if, =vlookup,
=lookup
or =hlookup

TIA