# function INDEX MATCH MATCH doesn´t work

1. ## function INDEX MATCH MATCH doesn´t work

Hi Folks!,

I'm trying to use the INDEX function combined with MATCH to lines and MATCH to columns. However, for some unknown reason, is not working. The follow link shows the details more accurately.

https://www.sendspace.com/file/2o9azy

I thank the help and attention of those who can contribute.

Thank U!

2. ## Re: function INDEX MATCH MATCH doesn´t work

Please upload your workbook to the forum, not all members are able - or willing - to access file-hosting sites

3. ## Re: function INDEX MATCH MATCH doesn´t work

Please attach the file in this website itself

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

4. ## Re: function INDEX MATCH MATCH doesn´t work

Change
=INDEX('SharePrice EUA_YyyyMmDd'!A1:CJ3132,MATCH(GO_EUA_1!B2,'SharePrice EUA_YyyyMmDd'!A1:CJ3132,0),MATCH(GO_EUA_1!A2,'SharePrice EUA_YyyyMmDd'!A1:CJ1,0))
As
=INDEX('SharePrice EUA_YyyyMmDd'!\$A\$1:\$CJ\$3132,MATCH(GO_EUA_1!B2,'SharePrice EUA_YyyyMmDd'!\$A\$1:\$A\$3132,0),MATCH(GO_EUA_1!A2,'SharePrice EUA_YyyyMmDd'!\$A\$1:\$CJ\$1,0))

5. ## Re: function INDEX MATCH MATCH doesn´t work

Based on the formula that nflsales posted, I would point out that the range used in MATCH must be a single column or row, not an array (multiple rows/column)...it appears that you have an array for the 1st match...A1:CJ3132

6. ## Re: function INDEX MATCH MATCH doesn´t work

If this was my file the first thing I would do is change those really long and hard to read sheet names!

7. ## Re: function INDEX MATCH MATCH doesn´t work

Good point, Tony, but I guess if you know what they represent, it wouldnt be so hard to read lol

There are currently 1 users browsing this thread. (0 members and 1 guests)