Ennumber of conditional IF statment

[sampath]

I have a very long if condition for my dashboard. kindly help me for my requirement which was mentioned below.

IF A1="CMO" and B1="S" then C1=12
IF A1="CMO" and B1="M" then C1=20
IF A1="CMO" and B1="C" then C1=40
IF A1="PDB" and B1="S" then C1=12
IF A1="PDB" and B1="M" then C1=24
IF A1="PDB" and B1="C" then C1=40
IF A1="FAV" and B1="S" then C1=8
IF A1="FAV" and B1="M" then C1=20
IF A1="FAV" and B1="C" then C1=32
IF A1="CTP" and B1="S" then C1=2
IF A1="CTP" and B1="M" then C1=8
IF A1="CTP" and B1="C" then C1=16
IF A1="SOU" and B1="S" then C1=4
IF A1="SOU" and B1="M" then C1=12
IF A1="SOU" and B1="C" then C1=32
IF A1="LAT" and B1="S" then C1=4
IF A1="LAT" and B1="M" then C1=8
IF A1="LAT" and B1="C" then C1=32
IF A1="Roof" and B1="S" then C1=4
IF A1="Roof" and B1="M" then C1=8
IF A1="Roof" and B1="C" then C1=16
IF A1="Seat" and B1="S" then C1=4
IF A1="Seat" and B1="M" then C1=8
IF A1="Seat" and B1="C" then C1=16
IF A1="FAR" and B1="S" then C1=4
IF A1="FAR" and B1="M" then C1=12
IF A1="FAR" and B1="C" then C1=32
IF A1="Top" and B1="S" then C1=2
IF A1="Top" and B1="M" then C1=4
IF A1="Top" and B1="C" then C1=8


Please help me for these conditions.

Regareds,
Sampath.S

 

[Nebu]

Hi:
If you have so many conditions it is better to create a look up table and retrieve values from there using index/match or vlookup.

Thanks

 

[Faseeh]

Hi Sampath

Please see attachment.

 

[Ramesh]

I second Nebu & Faseeh

Creating a lookup table is the ideal solution in such situation..

Here is the other way of doing this..