Cant drag down index match formula

**Sk8ect** · 04-18-2016, 12:29 AM

Screenshots : http://imgur.com/Zsw7MI2 http://imgur.com/PujQZQe

I am very new to excel so please bare with me.
I have made a spread sheet that searches for Transaction ID's from 'DownloadA'.
The fomula I used is: =IFERROR(INDEX(DownloadA!$Z:$Z,SMALL(IF($B$2=DownloadA!$N:$N,ROW(DownloadA!$Z:$Z),""),ROW()-9)),"")
That works when I drag it down. I have tried to change the formula to search for the date based on the transaction number.
The formula I used is: =IFERROR(INDEX(DownloadA!$A:$A,SMALL(IF(A10=DownloadA!$Z:$Z,ROW(DownloadA!$A:$A),""),ROW()-9)),"")
This works for the first cell I type that formula in.
The formula brings back the date for the first transaction ID but does not bring back the other dates when I drag the formula down. Any help would be greatly appreciated.

**SMILE** · 04-18-2016, 02:06 AM

You question is not very clear. Try remove the $ sign just before 2 ( Change $2 to 2) .

**FDibbins** · 04-18-2016, 02:25 AM

Sk8ect welcome to the forum

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you

Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

Having said that...
1. Avoid those full-column references after the INDEX
2. That is an ARRAY formul;a and needs to be entered using CTRL SHIFT ENTER, not just enter. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Cant drag down index match formula

LinkBack

Thread Tools

Rate This Thread

Display

Cant drag down index match formula

Re: Cant drag down index match formula

Re: Cant drag down index match formula

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] index match with array formula drag down problem

[SOLVED] This formula works but I don´t understand why Index(Index) match

[SOLVED] Index-Match drag in rows Horizontally

How do you drag down an index match function with multiple criteria?

[SOLVED] Concatenated INDEX MATCH formula that won't give error that can index match 2-4 strings

Index Match Index Formula work slow

Index/Match/Match. Formula looking veritcal and horizontal headings to find a match

Bookmarks

Bookmarks

Posting Permissions