Match

[Nick]

I have a table like this:

Week date
1 132
1 133
2 0
2 134
2 135
3 136
3 137

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 greater
than 0, but I don't know how to put it.

Can somebody help me on this?

NB OFFSET doesn't work here

Thx

 

[Mark Graesser]

Nick
If you will never have more then one row with zero you can use

=IF(INDEX(date,MATCH(2,week,0))=0,INDEX(date,MATCH(2,week,0)+1),INDEX(date,MATCH(2,week,0))

You might be able to get some other ideas from Chip Pearson's page

http://www.cpearson.com/excel/lookups.htm#LeftLooku

Good Luck
Mark Graesse
(e-mail address removed)

----- Nick wrote: ----

I have a table like this

Week dat
1 132
1 13
2
2 13
2 13
3 13
3 13

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

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

Can somebody help me on this

NB OFFSET doesn't work her

Thx