Try...

=IF(ISNUMBER(MATCH(D$7,{"Rehearsals","Day Off","Break","Travel"},0)),"No
Show",LOOKUP(2,1/(A2:G20),A2:G2))

Hope this helps!

http://www.xl-central.com

In article ,
stew wrote:

Hi Stefi

I want to replace the(D1+$B$30) part of the following formula with your
INDEX(2:2,,MAX(--(2:20)*COLUMN(2:2))).
This being an array formula how would I incorporate it into
=IF(D$7="rehearsals",("No Show"),(IF(D$7="DAY OFF",("No
Show"),(IF(D7="BREAK",("No Show"),(IF(D7="TRAVEL",("No
Show"),(D1+$B$30))))))))

Thanks For your time

Stew
"Stefi" wrote:

Try this:
=INDEX(2:2,,MAX(--(2:20)*COLUMN(2:2)))
It's an array formula, confirm it with Ctrl+Shift+Enter!
Regards,
Stefi

€žstew€� ezt Ã*rta:

Hi

I need a formula that will look along a row, to the left, and give me the
first number above zero

Thank you

Stew