excelbeginner1
New Member
- Joined
- Dec 13, 2014
- Messages
- 20
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
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