Do I use the offset function here?

[seethepuck]

This seems like I should be able to use the offset function on this case but I can't seem to get it to do what I need.

In the sample workbook, each row represents 1 week. I have Class Names listed in column C showing the class that will be starting in a given week. In column D the number of weeks until the graduation week. I am trying to add a formula to column E which will display the Class Name that will graduate that week based on the length of the class in column D.

Thank you for any guidance you can provide.

[FDibbins]

I know there is a better way than this, but it works.

Use a helper column (I used F, you can hide it is tou need to), put this into F4 and copy down...
=IF(C4="","",VLOOKUP("week "&MID(B4,6,2)+D4-1,$B$4:$B$11,1,0))

Then in E4, copied down…
=IFERROR(INDEX($C$4:$C$11,MATCH(B4,$F$4:$F$11,0)),"")

[hemesh]

or you could use =IF(D4="","",OFFSET(E4,D4-1,,,)) in c4 and drag down

[protonLeah]

Alternatively:

[seethepuck]

Thanks Ford-

It is working nicely in my sample. I will pull it over to my working project and tweak it to fit. Appreciate the assist.

Chris

[seethepuck]

Thanks Hemesh-

I need to "push" the info over to column E from Column C. In my actual project the names in column C are derived from some other formula and I can't pull them from column E using Offset.

[seethepuck]

Thanks ProtonLeah-

Good reference for organizing the overall class list and scheduling the release dates.

Thanks.

[seethepuck]

Hope you don't mind if I leave it open for a bit longer to see if others have additional solutions.

[seethepuck]

Ford-

Thanks again for the solution. I was able to fit the Index/Match combo portion of your solution to fit my project needs perfectly. Works like a charm!

[FDibbins]

Happy to help and thanks for the feedback