Excel Help

Closed
jaikrish_18 Posts 11 Registration date Monday February 23, 2009 Status Member Last seen April 15, 2009 - Mar 16, 2009 at 08:57 AM
amlports Posts 9 Registration date Wednesday November 5, 2008 Status Member Last seen May 18, 2009 - Mar 17, 2009 at 04:48 AM
Hello,
In my Excel Sheet
Column A-------------------Column B----------------Column C
10---------------------------10------------------------3
50---------------------------25-------------------------5
10--------------------------45-------------------------3
85--------------------------5--------------------------5
12-------------------------10-------------------------6
48-------------------------48-------------------------1
91-------------------------10-------------------------3
This is a set of data in 3columns
Now the result i'm expecting is if 10-10-3 in Column ABC check the Same in D,E,F if its match give10-10-3 r gvem ethe next higher number THE D,E,F Column data is
Column-D----------------Column E----------------ColumnF
10-------------------------15--------------------------3
55-------------------------20--------------------------30
58-------------------------30----------------------------10
10-------------------------30---------------------------10
25-------------------------50---------------------------10
87-------------------------10---------------------------30
48-------------------------10---------------------------5
93--------------------------5----------------------------5
93-------------------------10----------------------------5
Like this in Column D,E,F
Filrst it has to match the first row inABC(10,10,3)is there 10,15,3 Next is 50,25,5 no matching the same so next higher is 58,30,10 not 55,20,30
So like this iwant the result so pls provide the formula
What is the formula i can use to get the result
pl..........................S provide the formula
Related:

1 response

amlports Posts 9 Registration date Wednesday November 5, 2008 Status Member Last seen May 18, 2009
Mar 17, 2009 at 04:48 AM
hi,
try this link to get tutorials about matching:
http://www.articlejobber.com/tutorial/match_function_excel_20060219_1.html
0