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?