Excel Help

[Closed]
Report
Posts
11
Registration date
Monday February 23, 2009
Status
Member
Last seen
April 15, 2009
-
Posts
9
Registration date
Wednesday November 5, 2008
Status
Member
Last seen
May 18, 2009
-
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

1 reply

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

hi,
try this link to get tutorials about matching:
http://www.articlejobber.com/tutorial/match_function_excel_20060219_1.html