Excel Help

Closed
jaikrish_18 Posts 11 Registration date Monday 23 February 2009 Status Member Last seen 15 April 2009 - 16 Mar 2009 à 08:57
amlports Posts 9 Registration date Wednesday 5 November 2008 Status Member Last seen 18 May 2009 - 17 Mar 2009 à 04:48
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 5 November 2008 Status Member Last seen 18 May 2009
17 Mar 2009 à 04:48
hi,
try this link to get tutorials about matching:
http://www.articlejobber.com/tutorial/match_function_excel_20060219_1.html