A formula will only return a value to the cell it is in. It cannont send
values to other cells. If you want values in other cells, then those other
cells must each contain a formula of their own.

In your example, put this formula into cell EN17:

=IF(EG17="20214",EG20,"")

And then in EO17 put this formula:

=IF(EG17="20214",EH20,"")

etc, etc....

HTH,
Elkar


"achieve" wrote:

I am setting up multiple conditional statements. In the current one, I am
typing information (the conditional statement) into a cell, but rather than
the results show up in that cell, I want the results to show up in
different/multiple cells. For instance. I am inputting information into ER17.
The statement I am writing is "=IF(EG17="20214",
(EN17=EG20,EO17=EH20,EP17=EI20,EQ17=EJ20), "")" where the cell references on
the right side of the "=" contain information; those cell references to the
left of the "=" is where I want the information/result to show up. How do I
do this? Please advise right away. Thanks.