How to check 3columns data at 1 time

[Closed]
Report
Posts
11
Registration date
Monday February 23, 2009
Status
Member
Last seen
April 15, 2009
-
Posts
11
Registration date
Monday February 23, 2009
Status
Member
Last seen
April 15, 2009
-
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

1 reply

Posts
7
Registration date
Wednesday November 5, 2008
Status
Member
Last seen
May 18, 2009

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.
Posts
11
Registration date
Monday February 23, 2009
Status
Member
Last seen
April 15, 2009

pls tell me the formula of checking the 3 column data in