I have three Index/Match formulas spread across three different cells horizontally and am trying to combine into one combined (nested?) formula in a cell, but have not had any luck so far. Any ideas. See below. Thanks.
Please Login or Register to view this content.
What determines which 1 would supply the answer? Each 1 seems to be pulling from teh same range, but would select a different row based on the MATCH
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
Answer could come from any one of the three, but would only come from one of the three areas...
aahh ok DUH lol. maybe this...
{=IFERROR(INDEX($L$2:$L$5,MATCH(1,($J$2:$J$5>=B2)*($J$2:$J$5<=C2)*($K$2:$K$5=D2),0)),IFERROR(INDEX($L$2:$L$5,MATCH(C2+1&D2,$J$2:$J$5&$K$2:$K$5,0)),IFERROR(INDEX($L$2:$L$5,MATCH(B2-1&D2,$J$2:$J$5&$K$2:$K$5,0)),"")))}
Thanks FDibbins. That worked great..
Happy to help, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks