index and match formulae

Dear experts,

The formulae in cell c1 worked (logic) fine in other sheets, but in this particular case i am not getting the result can some help.

Thank you,

index-and-match-formulae.xls
ExcellearnerAsked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
Hello Excellearner,

Your last 2 MATCH functions are the wrong way round, in INDEX the row reference comes before column, so you need this version

=IF(COUNT(MATCH(C2,'date elements'!B3:K3,0)*MATCH(E1,'date elements'!A4:A9,0)),INDEX('date elements'!B4:K9,MATCH(E1,'date elements'!A4:A9,0),MATCH(C2,'date elements'!B3:K3,0)),0)

regards, barry
0
 
ExcellearnerAuthor Commented:
Barry,excellent once again.

Coordinator, since the correct formulae appears in the expertt's comment.

Can i reqeust the sample spread sheet attached to be deleted. As such it does not contain any confidential informtion. I would be comfortable if the sheet is deleted.

Thankyou
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.