Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Edit/Replace from Table
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!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Edit/Replace from Table
Look up the VLOOKUP formula. Its the simplest way to make this happen.
Steph wrote: 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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit and Replace with wildcards | Excel Discussion (Misc queries) | |||
Edit Replace formula | Excel Discussion (Misc queries) | |||
Edit Replace formula | Excel Discussion (Misc queries) | |||
Edit Replace | Excel Discussion (Misc queries) | |||
edit replace | Excel Discussion (Misc queries) |