trying to get a vlookup(median) that ignores zeros

[nhush]

I have already found the median value of a range of numbers with zeros using

=MEDIAN(IF(U12:U31<>0,U12:U31))

but I need a vlookup formula to match a name to the median number.

I've tried =VLOOKUP(MEDIAN(AB12:AB31),AB12:AC31,2,) but it doesn't work

Can anyone help me?

[martindwilson]

why do you show {=MEDIAN(IF(U12:U31<>0,U12:U31))}
then use MEDIAN(AB12:AB31) in the vlookup
also there is a fair chance the median will be 4.5 or such and if you have a list of integers it wont find a match.

[nhush]

I'm only discovering vlookup so I'm not sure what exactly you are saying.

If there are zeros in a list of numbers, can i just use the normal =median(A1:A10) formula?

And if i do, would the lookup formula be "=vlookup(MEDIAN(A1:A10),A1:B10,2)" ?

I'm confused!

[martindwilson]

i dont know only you can answer that why you are using median i dont know
but lets assume you are using either version this is what happens

[nhush]

Thanks... Now I understand why I am getting the #N/A sign.

So if I don' use median, how can I find a number that actually in the range of numbers whih is closest to the median?

[nhush]

Sorry! I don;t pay close enough attention to what you wrote in the attachment. You actually told me how to do it using an ascending list.