Excel help

[Sir Tokyo Sexwale]

I can use the 'if' formula, but I want a more complex one, in other words if (say) S2=worksheet2!A2,worksheet2!a6 but rather than being a simple true/false secnario, I want the false option to then run a new 'if'.

 

So basically, I have a budget by month on wksht 2 & I want column 'S' to pick up the relevant month's budget from that worksheet. It'll ask does S2 (march) = worksheet 2 march? If yes, then populate the column with March's figs, if no, then go on until it does find March

[SkippyjonJones]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[StevieC]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Sir Tokyo Sexwale]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[SkippyjonJones]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Sir Tokyo Sexwale]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here