Solved Can an IF statement populate multiple cells?

Microsoft Excel 2003 (full)
February 24, 2012 at 09:12:40
Specs: Windows XP, 1.0Gb
I am trying to figure out if there is a way that an IF statement can populate multiple cells.

Scenario: "Jones", "Thomas", "123 First Street", "Any Town', "Any State" is listed in a table in cells A1, B1, C1, D1 and E1, respectively, with similar lisitngs in cells A2:A10; B2:B10; C2:C10; D2:D10, and D2:D10. On a dfiferent worksheet, there are five cells for the five titles above, last name, first name, address1, city, and state.

I have been using an IF in each individual cell of the five cells to get the specified information. . Is there a way that one IF statement can populate all five cells?

Thank you.
Brian W

See More: Can an IF statement populate multiple cells?

Report •

February 24, 2012 at 10:16:31
✔ Best Answer
An Excel function can only "populate" the cell that it is in.

It's not really populating the's really just evaluating to an answer and displaying that.

I'm not sure what you are doing with the IF function - since you didn't post it - so I can't make any suggestions as to whether there is an easier/more efficient method to accomplish your goal.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

February 25, 2012 at 15:11:21
Dear DerbyDad03,

Thank you for your response. The IF statements I am using work fine; in fact, you helped me design them awhile ago.

Brian W

Report •
Related Solutions

Ask Question