if(or(offset HELP

[bluepenink]

Hello

can someone pls help me with the logic/formula for if(or(offset

basically, i have data in range D12:O12
D10:O10 = header (months, Jan-Dec)

issue with formula:
=IF(OR(D12:O12=0),OFFSET(D10:O10,-2,))

basically, i want the formula to work so, if the any of the cells in range D12:O12 = 0, then offset the last row by -2 (jump by two rows)

i.e.
Jan Feb Mar Apr May June
100 200 300 400 200 0

so my answer would be, June

can someone pls help!!

 

[jfish1288]

=INDEX(D10:O12,1,MATCH(0,D12:O12,0))

this is an array formula you have to type it then push ctrl+shift+enter after you enter it you should see

{=INDEX(D10:O12,1,MATCH(0,D12:O12,0))}

 

[bluepenink]

oh thxs so much buddy

one request, the formula works great, but its going to the zero like i mentioned, however, is it possible for it to go one back?

for example
right now i have some YTD data for august

so i would like for the formula to go to august; right now its going to september
i.e. in the range D12:O12, go to last active row (prior to zero) and go up 2 rows to get month?

is it possible to make it go to last figure that is zero and to back one? thx u so much

 

[jfish1288]

i may not be understanding what you want but try this

=INDEX(D10:O12,1,MATCH(0,D12:O12,0)-1)

 

[bluepenink]

perfect...thxs alot buddy!!!!!