Problems with index and match

[clowesr]

Hi

I'm having problems getting my index to work..

So for sample sake I have in my raw data

A B C D
1
2 Rob Dave Phil
3 01/01/2013 1 2 3
4 02/01/2013 1 2 3
5 03/01/2013 1 2 3


and in my front sheet I want to pull the data when I change the "Rob" by drop down


Rob

01/01/2013 Result
02/01/2013 Result
03/01/2013 Result

so if Rob is selected the results should be


Rob

01/01/2013 1
02/01/2013 1
03/01/2013 1

but its showing

Rob

01/01/2013 1
02/01/2013 2
03/01/2013 3

The formula Im using is E18 is the place the drop down for Rob,Dave and Phil is and D20 is where the dates start

=INDEX($A$2:$D$5,MATCH($E$18,$A$2:$D$2,0),MATCH($D20,$A$2:$A$5,0))

thanks

[Fotis1991]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[clowesr]

the table of data looks rubbish the way its come out so I have attached the data

[Fotis1991]

Just replace the MATCH part of your formula.

Please Login or Register  to view this content.

[Pete_UK]

Try it like this:

=INDEX($A$2:$D$5,MATCH($D20,$A$2:$A$5,0),MATCH($E$18,$A$2:$D$2,0))

You have your row and column parameters the wrong way round.

Hope this helps.

Pete

[clowesr]

as per previous post

[azumi]

Please see the files

Azumi

[clowesr]

oohhh yeah!!! so stupid! thanks guys it works perfectly now, maybe I should re-think of a career path away from resource analyst if I can’t tell the difference between row and column! :-)

[Fotis1991]

You are welcome and thanks for the feed back.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.