<IF> Formula

G

Guest

formulas return values. what you are asking is that a
formula perform an action i.e. copy and move. not possible.
you could if all was on 1 row by placing a if formula at
M,N,O but from your example, you want it to go to
different places based on what is in column a. not
possible.
-----Original Message-----
Is there a formula where I can achieve the following:

If (for instance) A4 reads "AD", copy B,C,D4 to M,N,O16
If A4 reads "WH", copy B,C,D4 to M,N,O21

If I have more than one item designated as "AD" or "WH"
Click to expand...
or any other 2-letter name in column A, can the ones after
the first copy to M,N,O16 be automatically and
successively be copied to M,N,O17, M,N,O18, etc?
 
Top