Matching

  • Thread starter Thread starter Nick
  • Start date Start date
N

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
 
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
 
Back
Top