Hello
Is it possible to nest multiple INDEX and MATCH functions?
A singular function works for one range of information thus: =IF(D8=0,"",(INDEX(D20:D29,MATCH(D8,C20:C29,0)))) VLOOKUP also works for a single range.
But I have 8 ranges consisting of 2 columns of information (with 10 entries each) thus I need 10 INDEX/MATCH functions.
Please see the attached for further information.
Thanks in advance for your help.....
Hi,
maybe in G8
=IF(D8=0,"",(INDEX(C20:D29,MATCH(D8,C20:C29,0),MATCH(C8,C18:R18,0)+1)))
Regards
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Please try this function.
=INDEX($C$13:$R$22,MATCH($D8,INDEX($C$13:$R$22,0,MATCH($C8,$C$11:$R$11,0)),0),MATCH($C8,$C$11:$R$11,0)+1)
Please click 'Add reputation', if my answer helped you.
Yes, it's possible to next Index/Match; another option is to run a dummy column that finds a MATCH and feed that into multiple INDEXes.
Here is not really clear to me:
1) The input
2) The table from which you are looking up data associated with the input
3) What the output(s) are
Thank you very much, this formula works perfectly.
Hi dontaylor,
Thank you so much for the feedback.
Please try this function as well.
=VLOOKUP($D8,OFFSET($C$13,,MATCH($C8,$C$11:$R$11,0)-1,COUNTA($C$13:$C$22),2),2,0)
Hello Ramananhrm
Thanks for the formula, I will try this one tomorrow as well.
Thanks Again...
Hi Ben
Thanks for your reply.
Please see Ramananhrm's reply above it works perfectly.
Regards
Don Taylor.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks