LinkBack URL
About LinkBacks
I'm fed up.
Why doesn't this formula work in cell D6:
=INDEX(A9:D13,MATCH(C2,D9:D13,0),A9:A13)
and what is the correct formula?
excel help 3.xlsx
I'm fed up.
Why doesn't this formula work in cell D6:
=INDEX(A9:D13,MATCH(C2,D9:D13,0),A9:A13)
and what is the correct formula?
excel help 3.xlsx
derivative_x,
In plain English(not Excel!) what are you trying to achieve? What should the result in D6 be?
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
Try this
Index only Column A and Not A:D
Formula:
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
the last part of your index() should be a col number (normally 1), not a cell range
=INDEX(A9:D13,MATCH(C2,D9:D13,0),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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks