Help in finding Value in Index Array
I misunderstood, I thought you were looking for zero in column G, this will
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)
--
Regards,
Peo Sjoblom
"George" wrote in message
...
Hi Peo,
Thanks, but the formula below returns the first value in column C (after
row
5), but I am actually looking for the first positive value in column G
after
column C declines to an empty cell.
"Peo Sjoblom" wrote:
One way
=INDEX(C5:C400,MATCH(TRUE,INDEX(INDEX(C5:C400,MATC H(1,(G5:G400=0)*(G5:G400<""),0)):C400,0)0,0)+MAT CH(1,(G5:G400=0)*(G5:G400<""),0)-1)
entered with ctrl + shift & enter
--
Regards,
Peo Sjoblom
"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!
|