Edit/Replace from Table

  • Thread starter Thread starter Steph
  • Start date Start date
S

Steph

Hi. Is it possible to do an Edit/Replace from a table? Basically, Column A
of Sheet 1 is the data. In Sheet2(A2:B20) I have the table to base the
replace off of. I would like to loop through the table, find the contents
of A2 in the data, and replace it with B2, then loop through the rest of the
table. Thanks for your help!!
 
Look up the VLOOKUP formula. Its the simplest way to make this happen.
 
You must log in or register to reply here.

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

Edit/Replace from table or named range? 3
MS word Find and Replace using Regex - Help required 0
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
How to Populate Data from a table to another 0
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
search and replace data 7
VBA - retrieve data on last create named range from previous inserted named range 0
modified pivot table using a macro 2

Back
Top