Then this should work

=INDEX(C5:C400,MATCH(TRUE,INDEX(INDEX(C5:C400,MATC H(TRUE,G5:G400="",0)):C400,0)0,0)+MATCH(TRUE,G5:G 400="",0)-1)


array entered


--


Regards,


Peo Sjoblom



"George" wrote in message
...
By null value, I mean the cell will be Empty (blank, unused).
Thanks,

"RagDyer" wrote:

You have to be *very* precise in your terminology!

What *exactly* do you mean by "null value"?
Empty (blank, unused) cell
Zero length string ( "" )
0 in cell
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"George" wrote in message
...
I am trying to search a column (C5:C400) to find out when it runs to a
null
value, then search down a different column (G) starting from that same
row
and return the first positive number found.

Can anyone help? I've been using the following as a starting point, but
I'm
stuck on how to complete it.

=INDEX(MATCH(TRUE,G5:G4000),MATCH(TRUE,C5:C400=0, 0))

Thanks!