One too many...

[daowen]

Seems like I found a good area to ask questions in.

Okay, this snip-it is an inserted formula in a cell. It looks at a certain sheet named with a variable.

Problem - The formula is off by one column. How do I change it to the right column?

Please Login or Register  to view this content.

Returns this formula:

Please Login or Register  to view this content.

I need it to return this formula:

Please Login or Register  to view this content.

Any help is greatly appreciated and warmly received.

Doug

[JBeaucaire]

It's the "C" values you need to adjust:

Please Login or Register  to view this content.

All the "C" values that are off, adjust them as shown.

[daowen]

YOU THA MAN!

Thanks! My one project is finished now for work. It was a long week and that was the only thing really that tied me up.

I really appreciate the fast response.

Doug

[JBeaucaire]

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)