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.

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.

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.

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.

Ask Your Question

Weekly Poll