Hi, Im 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 dont want use =if, =vlookup, =lookup
or =hlookup

TIA