Hello
Having some trouble with the following formula that I have managed to mess up
=INDEX($C$4:$K$16,MATCH(E20,INDEX($C$4:$K$16,1,),0),MATCH(C20,INDEX($C$4:$K$16,,2),0),C20,1)
I have attached a sample with a "red" cell outlining the issue.
Basically, i want C20 to change what i am looking for. i want to search by position (row 4) and then show the respective data for it.
i want to implement an "option" button on another worksheet, so i want to make cell link C20.
pls help!
Last edited by jw01; 09-13-2011 at 02:18 PM.
is the result you are looking for in this instance supposed to be 21?
=INDEX($C$4:$K$16,C20,MATCH(E20,INDEX($C$4:$K$16,1,),0))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
maybe 14?
=INDEX($D$5:$J$16,MATCH(C20,C5:C16,0),MATCH(E20,D4:J4,0))
Windows 7 using Office 2007 & 2010
Remember your [ code ] [ /code ] tags, makes reading soooo much easier
this happen to do the trick! thx u so much!Originally Posted by scottylad2
NBVC, i appreciate the prompt response, you guys are the best
cheers
Or...
=INDEX($C$5:$K$16,C20,MATCH(E20,$C$4:$K$4,0))
could do it too.
Last edited by NBVC; 09-13-2011 at 02:24 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
jw01 
Register To Reply
Bookmarks