By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,988 Members | 1,360 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,988 IT Pros & Developers. It's quick & easy.

Populating on cell based on another cell's criteria.

P: 34

I don't know if this can be done via Excel formula, or VBA, but I have an if statement in one column that will return the number "1" if the condition is true.

I.e. J10 = 1 as C10 is true to the condition.

I'm importing the cell C10 so it's always changing, so a formula would be wiped out, however if J10 is true (and equal to "1"), I'd like C10 to read "TOTAL".

Hopefully this makes sense. I was thinking of placing some sort of statement in column K (K10?) that if J10=1, then offset (0,-8) and enter the word "TOTAL"... only thing is that I don't know how to do that.

Any help would be appreciated!

Jun 24 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.