Multiple true in multiple cells in Excel

Microsoft Microsoft office excel 2007 ac...
October 29, 2010 at 08:08:03
Specs: Macintosh
I'm attempting to write an If Then statement in excel that yields multiple true results. For example, if a client enters A1 in F6, then Race1 will appear in G6. At the same time, Peak2 will appear in G5, Peak1 will appear in G4, Build2-4 will appear in G3, and Build2-3 will appear in G2. I'm clear on how to write an If Then statement for one true response (e.g. =IF(F40="A1","Race1","")) but I'm not clear on how to write it in a way to yield multiple responses in multiple cells. Any assistance would be appreciated. Thank you for any help.

See More: Multiple true in multiple cells in Excel

Report •


#1
October 29, 2010 at 08:47:26
I'm not sure I completely understand what you are trying to do, but an Excel formula can only produce a result in the cell in which it resides.

In other words, a formula in F40 can only produce a result in F40. It can't put anything in G6 or any other cell.

Your choices are:

1 - A formula in each cell where you want a result.
2 - A VBA macro that can monitor a cell or cells and basically put whatever you want where ever you want it based on the value in that cell.


Report •

#2
October 29, 2010 at 08:55:25
Hey DerbyDad03,

Thanks for responding so quickly. Based upon your answer, it seems as if I need to look into a VBA macro. It seems as if a formula will not work because I need data in multiple cells. Do you have a recommendation as to where to get started to learn about VBA macros? Thanks.


Report •

#3
October 29, 2010 at 09:48:33
Why can't you use a formula in each of the cells where you need "data?

You should post a little more detail about what you are trying to do. Examples of "inputs" and "outputs" would help.


Report •

Related Solutions


Ask Question