Jump to content
By fans, for fans. By fans, for fans. By fans, for fans.

Recommended Posts

Posted

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...