Need a different find and replace?
 

I am working on a VERY LONG spreadsheet. The only problem is when i populate
data (living document), it is all done manually.
Is there a way to Find something in column A if TRUE type "x" in column G.

Much like find and replace but not for ONE cell at a time. I need to look
for varialble in column 'A' and if it matches input goes in column G.
thanks for any help. I am starting to think Excel can't do this.
Thanks again.

Need a different find and replace?
 

Maybe something like this.
In column G, say G1:

=IF(A1="variable","x","")

Copy down as far as needed. If this is not what you need, then please
elaborate on your data and the desired results.

Regards,
Paul

--

"Tom" wrote in message
...
I am working on a VERY LONG spreadsheet. The only problem is when i
populate
data (living document), it is all done manually.
Is there a way to Find something in column A if TRUE type "x" in column
G.

Much like find and replace but not for ONE cell at a time. I need to look
for varialble in column 'A' and if it matches input goes in column G.
thanks for any help. I am starting to think Excel can't do this.
Thanks again.

Need a different find and replace?
 

in G1:

=If(a1=true,"x","")

Replace true with your test

Is this what you want?

"Tom" wrote:

I am working on a VERY LONG spreadsheet. The only problem is when i populate
data (living document), it is all done manually.
Is there a way to Find something in column A if TRUE type "x" in column G.

Much like find and replace but not for ONE cell at a time. I need to look
for varialble in column 'A' and if it matches input goes in column G.
thanks for any help. I am starting to think Excel can't do this.
Thanks again.