| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to search in one column, and replace in the other column if fo
I have multiple data in Column A, these data have a value in column B, I am
looking at a way (via VBA) to go from A1:A100 looking for curtain names (say €śAdnan€ť, €śJohn Smith€ť,€ťJohn Doe€ť) and change their value in column B to sy for Adnan 10, for John Smith 25, and for John Doe = 65 wherever they are (they exist in more then two places). These values could be text, numbers, date or currency. Thank you, Adnan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find & Replace - Limit search to a specific column | Excel Worksheet Functions | |||
| Search a column for values, return a value from adj column | Excel Worksheet Functions | |||
| LookUp Function with Two Column Search Returning One Column Value | Excel Worksheet Functions | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| Replace all non blanks in a column with column header | Excel Discussion (Misc queries) | |||
Threaded Mode
