Need a different find and replace?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index/match across multiple columns? 19
VBA- IF statement to replace cell contents 0
How can I search for words in a list with a macro? 4
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
Find and Replace variable string 11
Satisfying two variables entered via popup 1
Find * and Replace 4
Macro: finding a cell on one worksheet and copying to another worksheet 0

Back
Top