Match

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