One way:

In Sheet3:

G1: =IF(Sheet1!$G$4="d",Sheet1!G1)

Copy G1 down to G3

A formula can only return a value to its calling cell, it can't change
other cells' value.


In article ,
beez wrote:

I am trying to get excel to do the following and have no idea where to
start....

On sheet three, I want cell g4 to look at sheet one's g4 space and determine
if the letter "d" is there. If it is, I want it to copy cell's g1-g3 into
sheet threes g1-g3.

Is there any possible way of accomplishing that?

Thanks..

Brett Zent
PC Technician