Check out some problems solved by our top Experts or click here to post your own problem for free!

All solutions
INDEX

help with
INDEX(IndexArea,MATCH($M$5,MatchRows,0),MATCH($M$6,MatchColumns,0))

Solved by Z. Y. in 12 mins

I have a formula which I am trying to append, I would like to add d2:d301 to it. I've inherited the formula so not sure how to add to it
current formula is
=iferror(if(row()<>2,INDEX(arrayformula(filter($P$2:$P301,$C$2:$C301<>"",row($C$2:$C301)=max(if($C$2:$C301=C302,row($C$2:$C301),0)))) ,1),0),0)

Solved by A. H. in 60 mins

Trying to get the sheet name in the formula below to change based on the text in a specific cell. So in the example below, if the text in cell A1 is currently "Sheet 1" and i change it to "New Sheet Name", the formula below would read that and replace 'Sheet 1'! with 'New Sheet Name'!
=IFERROR(INDEX('Sheet 1'!$G$8:$G$2000, MATCH(0,COUNTIF(O$2:O3, 'Sheet 1'!$G$8:$G$2000), 0)),"")

Solved by E. W. in 31 mins

I need a formula that will pull items from a certain column, depending on two other criteria related to two other columns, and print out every instance that matches all of the above once and only once, and stop printing when all instances are printed. Currently have been relying on this for half of the job (printing one, and only one, instance of every unique element), but have not been able to incorporate the other two criteria: =ArrayFormula(index(RawData!$E$2:$E$500000, match(0, COUNTIFS($C$1:$C12,RawData!$E$2:$E$5000),0)))

Solved by I. F. in 60 mins

I need a formula that will compare multiple columns, and return the column header name of whichever column had the highest value. I am using (INDEX($F$1:$K$1,0,MATCH(MAX(F2:K2),F2:K2,0))) , but one row had all the same values and the formula returned the first column header as being the "winner". This formula cannot distinguish when there are ties.

Solved by M. C. in 51 mins

I need help with a formula that uses index and match along with small, row and if statements to return multiple rows and columns of data from a matrix

Solved by Z. W. in 39 mins

hi can you tell me: what does index on column % mean?

Solved by O. D. in 20 mins

Hello ..!!!! i have Question regarding Excel Index & match Function.

Solved by O. C. in 60 mins

I need help on index and match where the return is not correct

Solved by B. B. in 20 mins

Hi I'm trying to use fuzzy lookup.
Not sure how it's working.
I have two strings which are different ('Unemployment Benefits' vs 'Invalid pensioner'), yet getting a similarity index of 0.9474.

Solved by E. E. in 40 mins