Hi,

I tried the find formula as well. Doesnt seem to work.
One of Ron's formula works. Am going to go with it for the moment.

Thanks for for patience & effort.

Regards
Rajula


"Rick Rothstein (MVP - VB)" wrote:

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

Is that the list of numbers you want us to reproduce for you? Do you really
think we would have been able to deduce that from this explanation from your
first post?

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.

Alright, if those are the values you want, give this formula a try...

=FIND(A1, "ABCDE")*FIND(B1,"VWXYZ")

Rick