Return A Cell Value Based On the First Occurrence of data

[pauleapo]

Hard to explain what I am after, but here goes....

I have a planner set up, from column AF in row 7 the header is for week-commencing dates, underneath the columns in each week I input a number of hours per week assigned to a task. What I want to do is return the value in row X, header 'Manfacture (Week Commencing) from row 7 for the first time it encounters a value in the range across the row, this being the week I start the task. As below I have this working using a lookup and this is all fine and dandy until the task spans more than one week, it then only returns the cell data from row 7 once it has 'summed' to equal what is in the column 'V'. If you look at the below picture I have highlighted the cell where this formula doesn't work it returns the date for the second week of the process which spans two weeks.

This is the formula I am using:

=LOOKUP(V8,AF8:BO8,$AF$7:$BO$7)

Hope you can make sense of the above

Any help would be greatly appreciated

Thanks

pauleapo

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[pauleapo]

Hi Fluff,

Apologies a few years since I last used this forum for help....

Windows OS using Excel 365

Thanks

P

 

[Fluff]

Thanks for that.
How about

=INDEX(FILTER(AF$7:BO$7,AF8:BO8<>0,"none"),,1)

 

[pauleapo]

That works perfectly, thank you so much

P

 

[Fluff]

You're welcome & thanks for the feedback.