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?

Hi

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

Arvi Laanemets


"Nathan McElmurry" <Nathan wrote in
message ...
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?