Solved

index and match formulae

Posted on 2011-02-11
2
152 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:Excellearner
2 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
Comment Utility
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
 

Author Closing Comment

by:Excellearner
Comment Utility
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

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now