# My formula in excel will not work

Can someone look at the excel example that I downloaded, and tell me what I did wrong? The yellow high-lighted is what I am wanting to accomplish and the light-blue is what I am getting with the formulas I created and am stumped as to what I am doing wrong?
The first part  -- IF(ROWS(\$F\$6:\$F6)>COUNTIF(Amount,">0"), -- is working fine but the Index fuction  --  INDEX(\$A\$6:\$A\$19,SMALL(IF(Amount>0,ROW(Amount)-ROW(D\$6)+1),ROWS(F\$6:F6))) -- is not working.

In this example, 7 names have amounts in the amount column, and if another name (for instance Susie) would have an amount that needs to dynamically show also.
learning.xlsx
###### Who is Participating?

x

Commented:
The formula in F6 is an Array formula.  You need to confirm it with CTRL+SHIFT+ENTER not just ENTER so that you see { } brackets appear around the formula... then you can copy it down.

Also to get rid of the #N/A in the VLOOKUP columns, add an IFERROR()

e.g. in G6:

=IFERROR(VLOOKUP(\$F6,\$A\$6:\$D\$19,2,FALSE),"")

copied down
0

Author Commented:
Thank you so much for your help.  Your solution worked beautifully.  I would not have figured that out on my own.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.