| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching and Matching Lists
Pls help with a macro to solve the task below:
Sheet1, column A has an unfixed or undetermined range of names starting at "A2". Sheet2 column A has a related name list also. For every item in sheet2 column A, search through sheet1 Column A Where a match is found, indicate "PRESENT" in the corresponding cell in Sheet2 column B. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Searching Lists | Excel Discussion (Misc queries) | |||
| Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
| Searching and matching in sheet (urgent) | Excel Worksheet Functions | |||
| Searching for a particlar value and matching to a name.. | Excel Worksheet Functions | |||
| Formula for Searching & matching two values in excel | Excel Discussion (Misc queries) | |||
Threaded Mode
