Using MATCH and INDEX

[mariohache]

I just want my table to select values from a droplist located in O14

I have defined a name called months. It includes jan, feb, ... dec and from there I created the droplist.

I also defined names for the 12 months (one for January, one for feb...) which includes the value I want to show in my main page. Each one has its column.

I am trying to combine values from two different MATCH functions.

Here is the working syntax

=IF(ISTEXT(D18),INDEX(February,MATCH(D18,NAME,0)),"")
=IF(ISTEXT(D18),INDEX(March,MATCH(D18,NAME,0)),"")
=IF(ISTEXT(D18),INDEX(April,MATCH(D18,NAME,0)),"")

and so on...

however I am receiving a #ref error when I type this

=IF(ISTEXT(D18),INDEX(MATCH(O14,Month,0),MATCH(D18,NAME,0)),"")

I just want my table to select values from a droplist located in O14

Any ideas?

Thanks a lot

[Tony Valko]

Looks like you need to include a range for the INDEX function.

The syntax should be:

INDEX(range,row number,column number)