Need a different find and replace?

T

Tom

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.
 
P

PCLIVE

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
 
Top