Matching

[Nick]

I have a table like this:

Week date
1 132
1 133
2 0
2 134
2 135

I would like to get a match for the beginning of week 2,
that should be 134 here.

I tried this
=INDEX(date,MATCH(2,week,0)) but it returned me a 0. I
guess it needs a condition where date should be different
of 0, but I don't know how to put it

Can somebody help me on this?

Thx

 

[Roger Govier]

Hi Nick

Does each new week always start with a 0?
If so, you could use the OFFSET function to take the next row but use the
same column.
=OFFSET(INDEX(date,MATCH(2,week,0)),1,0)
which will return 134

 

[Guest]

Sometimes yes, but most of the time not. Do you know the
answer for this?

Nick