I don't know why you're getting #N/A. The formula seems fine and should
return 22.96...

In article ,
nobbyknownowt wrote:

Thanks for replying but that doesnt do it.
See if it helps if I explain a little more!
My list address is r2:r271 and my target is a27.
there are answers in the list calculation I am working on of -21.05 /
15.22 / 22.96 / 30.70 (unfortunately almost 200 of each as I started
with a simple calculation!!) they are sorted in order.
=vlookup(a27,r2:r271,1) returns 15.22 (the answer i need is 22.96 a27
total being 22)
=index(r2:r271,match(min(abs(r2:r271-a27)),(abs(r2:r271-a27)),0))
returns #N/A even when i ctrl shift enter
The calc steps follow through as
=index($r$2:$r$271,match(43.054469292902,43.054469 292902,0)
=index($r$2:$r$271,#N/A)
I can see where its wrong but dont know enough about this function to
see why? (To be honest cant see how its supposed to work!?&£)

I thought i also may be able to remove the multiple entries (the
results are identical) but i need a way I can do this that will keep
the columns in line and ignore blank entries.

cheers
nobby