VLOOKUP SUMIF Formula

[jj554]

Good evening,

I am inexperienced with the VLOOKUP function and I believe it is necessary to put together a formula I need. Please see the sample workbook for details. Any guidance will be greatly appreciated. If there is a way around the VLOOKUP, do your thing...I'm open to anything.

Thanks for the help!

[bebo021999]

Try this in G3:

Please Login or Register  to view this content.

Confirmed by holding both Ctrl-Shift, then Enter
Drag down

[Tony Valko]

Try this...

Entered in H3 and copied down:

=IF(F3="","",IFERROR(1/(1/(A3-INDEX(A$3:A$67,MATCH("zzz",E$3:E3)+1))),B3))

For those cells that return the value from column B, you'll have to format them in the same format as column B.

[jj554]

thanks @bebo021999, it works great.

[jj554]

Thanks Tony

[Tony Valko]

You're welcome!