Hi Rick,
I used this formula. I am getting the values. The values should be betn 1 & 25
1
16
23
33
46
66
81
88
98
111
121
136
143
153
166
201
216
223
233
246
261
276
283
293
306
=5*FIND(A1,"ABCDE")+FIND(B1,"VWXYZ")-5
"Rick Rothstein (MVP -
VB)" 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
This simple formula should do what you want...
=5*FIND(A1,"ABCDE")+FIND(B1,"VWXYZ")-5
Rick