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!
Please upload your workbook to the forum, not all members are able - or willing - to access file-hosting sites
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Please attach the file in this website itself
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
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))
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
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
If this was my file the first thing I would do is change those really long and hard to read sheet names!
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
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)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks