Hi Gary,

It works almost fine. There are some problems.
The matrix is like this
V W X Y Z
A 1 2 3 4 5
B 2 4 6 8 10
C 3 6 9 12 15
D 4 8 12 16 20
E 5 10 15 20 25

If A1 is A & B1 is V then C1 = 1 or
If A1 is A & B1 is W then C1 = 2 or
If A1 is B & B1 is V then C1 2.

This makes it slightly complicated.. Any way of solving this?

Regards
Rajula


"Gary''s Student" wrote:

In another column, F enter:

AV
AW
AX
AY
AZ
BV
BW
BX
BY
BZ
CV
CW
CX
CY
CZ
DV
DW
DX
DY
DZ
EV
EW
EX
EY
EZ


then:

=MATCH(A1&B1,F1:F25)

no "if"s required
--
Gary''s Student - gsnu200733


"Rajula" wrote:

I have to incorporate this in a IF statement or whatever is simple. Does
anybody have a simple solution for this?

Cell A1 can have 5 values A,B,C,D or E
Cell B2 can have 5 values V, W, X, Y or Z

Value of Cell C1 is dependent on A1 & B1

ie IF A1 = A & B1 = V, then C1 = 1
If A1 = A & B1 = W then C1 = 2
If A1 = A & B1 = X then C1 = 3 & so on.... THere are 26 combinations. What
is a easy way of writing this formula

Kind regards