#NUM! help please

[Us2022]

Hi Everyone! How can i fix #NUM! in Excel 2016.

I am using= IF(ISERROR(SMALL(V:V,ROWS($J$13))),"",INDEX(J:J,MATCH(SMALL(V:V,ROWS($J$13:J30)),V:V,0))). I would like the cell to just be blank, rather than the #NUM! Can you please help.

Thank you in advance!

[#2 · Accepted solution]

@Us2022 Not really sure your you are trying to achieve here, but perhaps like this:

=IFERROR(INDEX(J:J,MATCH(SMALL(V:V,ROWS($J$13:J30)),V:V,0)),"")

[#3]

I listed items and left blank rows between the items. I wanted to use a formula to clear the blanks by having the items automatically shift up. Thank you so much!!! That worked perfectly!