MATCH AND INDEX FORMULA

[excelbeginner1]

Good day

Please could you assist me with the following formula, not sure were I am going wrong.

=INDEX($D$2:$AA$30,MATCH(1,(A42=A2:A30)*(B42=B2:B30)*(C42=C2:C30),0))

Ineed the information from the top rows to show under the results.

Thank you

 

[DanteAmor]

Could you put what result you want.
And explain a bit, how you get that result.
For example for the first search: "Zone 7", "Stage 1-2", "Monday", "14:00", "16:00" , what result do you want?

NOTE XL2BB:
For the future, it would help greatly if you could give us the sample data in a form that we can copy to test with, rather that a picture.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[excelbeginner1]

Could you put what result you want.
And explain a bit, how you get that result.
For example for the first search: "Zone 7", "Stage 1-2", "Monday", "14:00", "16:00" , what result do you want?

NOTE XL2BB:
For the future, it would help greatly if you could give us the sample data in a form that we can copy to test with, rather that a picture.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Hi the results would be 0 for that example, however should the value under the start column change to 03 then the result would be 04 05




Thanks i will do that in the future. i found away to do it.