hi freinds,
i have a problem, i am new to excel formulas i want to find value which is next higher than d13 cell value in a range d3:d8 and return the higher value to a cell
this will be helpful for me if you solve the problem thanks in advance
thanking you
green
Calc.xlsx
Last edited by green369; 06-11-2015 at 04:08 AM.
See if this is what you want?
=INDEX($D$3:$D$8,MATCH($D$13,$D$3:$D$8,-1))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
hi
Fdibbins
ihave seen your reply and used the formula how i can edit the formula to use for other cell values that is d14, d15,d16 ..........etc
thanks in advance
Not sure what you mean? Something like this?
=INDEX($D$3:$D$8,MATCH($D13,$D$3:$D$8,-1))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks