Who can solve this problem

Closed
jaikrish_18 Posts 11 Registration date Monday February 23, 2009 Status Member Last seen April 15, 2009 - Mar 16, 2009 at 05:56 AM
 Blocked Profile - Mar 16, 2009 at 10:30 AM
Hello,
how to check 3columns data at 1 time.for example:-
ColumnA---------ColumnB----------ColumnC
87----------------15-------------------20
10----------------20-------------------40
44----------------28-------------------60
55----------------5---------------------5
20---------------10---------------------10
58---------------40---------------------30
100--------------200-------------------100
&
ColumnD-------ColumnE--------------ColumnF
15----------------15--------------------10
88-----------------40-------------------30
57-----------------20--------------------30
48-----------------20--------------------60
55------------------10-------------------10
25------------------15-------------------20
58-------------------40------------------60
100------------------200----------------100
Like this and more data asr there now the problem is the formula is not checking this ABC data.
Actually it has to check first 87 15 20 equal number is there r not no means next higher number has to check 88 40 30 .So the formula has to check this 3 column data and refer with other 3 column data if its matches give the same r otherwise next higher number's hast to come. Important is it has to chek 3column data together and refer the same in next 3columns.
So pls any one pls help me how to solve this & what is the formula i can use......
pls tell me the formula
Reply with formula i'll be very greatfull to u...........
Thank U
JAI

1 response

Blocked Profile
Mar 16, 2009 at 10:30 AM
Not me, because i really don't get what the problem could be. Sorry!!!
0