Invalid Value error on INDEX MATCH formula

System

This discussion was created from comments split from: How to Index Match.

little meat

Can anyone help to check this Index formula?

INDEX(Jan@row:Mar@row, MATCH(MAX(Jan@row:Mar@row), Jan@row:Mar@row, 0))

I kept receiving "invalid value"

Gillian C

Hi @little meat

I'm not sure what you are trying to accomplish with your formula?

It looks like you are trying to find the maximum value between Jan and Mar? If so could you not just use =MAX(Jan@row:Mar@row)?

Paul Newcome

@little meat I agree. Just using the MAX function should get you what you need. If you are still getting that error, how exactly are the referenced columns being populated?

little meat

Hi Paul, I also want to return the month value after maximum value is finding , so that's why I use Index formula, but I don't know why it doesn't work.

Paul Newcome

In that case you would just use the MATCH/MAX combo and get rid of the INDEX function altogether.