How to check 3columns data at 1 time

Closed
jaikrish_18 Posts 11 Registration date Monday February 23, 2009 Status Member Last seen April 15, 2009 - Mar 2, 2009 at 04:55 AM
jaikrish_18 Posts 11 Registration date Monday February 23, 2009 Status Member Last seen April 15, 2009 - Mar 5, 2009 at 02:14 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......
Thank U
Jai
Related:

1 response

guizmomo Posts 7 Registration date Wednesday November 5, 2008 Status Member Last seen May 18, 2009
Mar 3, 2009 at 02:49 AM
hi,
try this link to get all the formulas you may need in excel:
https://books.google.mu/books?id=IFxnNpHFEOQC&dq=excel+formulas&printsec=frontcover&source=in&hl=en&ei=QaefSfPXNJz47AON2bXCCg&sa=X&oi=book_result&ct=result#PPP1,M1
you will surely find what you are searching for in it.
0
jaikrish_18 Posts 11 Registration date Monday February 23, 2009 Status Member Last seen April 15, 2009
Mar 5, 2009 at 02:14 AM
pls tell me the formula of checking the 3 column data in
0