#NUM! help please

New Contributor

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 Replies
best response confirmed by Us2022 (New Contributor)

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

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!