I'm trying to create a proof of a Median calculation. To do so in one cell
I've calculated the median using the formula (N/2)+1, that gives me the
position in an array which should equal the median value. In a second cell I
need to use LOOKUP to find that position and extact the value to complete my
proof. I seem to be writing the formula wrong though. I'm looking across a
range of arrays, here's the formula I've used:

=LOOKUP(CM5,(E22:E380,Z22:Z165,AU22:AU132,BP22:BP1 38))

It returms a value of #N/A. I'm not sure if that means that the formula is
incorrect or the value I'm looking for can't be found.