multiple IF statements

[Nathan McElmurry]

i can't seem to write a formula that does the following:

if cell C3 = 1X1, return 725 as the value; if cell C3 = 1X2, return 872 as
the value; if cell C3 = 2X2, return 1003 as the value; if cell C# = 3X2,
return 1156 as the value.

any suggestions?

 

[Arvi Laanemets]

Hi

=CHOOSE(MATCH(C3,{"1X1","1X2","2X2","3X2"},0),725,872,1003,1156)

Arvi Laanemets