Failed Lookup based on small function

G’day Excel forum having a bit of a problem performing a lookup based on the ‘SMALL’ function and could use a hand, I’ve attached an example spreadsheet so my nonsensical ramblings make more sense.

I’m attempting to calculate the ‘point ID’ (Distance Array column B rows 10 – 17) value of the nth (Point ID lookup sheet column B) closest point (Point ID lookup column E) by finding the nth smallest value in the corresponding range (Point ID lookup column C) on the Distance Array sheet. While this works perfectly for most points some don’t seem to work at all, the values exist in the subject range so I’m not sure why the lookup keeps returning ‘#N/A’.

Does anyone out there have any idea what’s going on here? The only thing I can think of is some kind of rounding error.

More importantly does anyone have any idea how to resolve this issue?

how do I upload an xls here?

Hi Fotis
I did exactely what you suggested before asking the question. I use the browser at work, and it does not allow me to upload anything. no need for a new thread I was just trying to answer the question above using an xls.
Thank you for your help, anyway! :D

Thank you all for your prompt responses and my apologies that mine has not been, I’d have replied sooner but have been overseas, Debraj Roy can’t thank you enough for your solution mate it worked flawlessly.

Regards
MattRNR