| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell matching and further cell replacing
I'm trying to find a formula that can match account numbers from 2 different pages (cells, as I have merged the pages) and take the data beside one account number and add it to the relevant cells beside it's matching account number. I basically have have a dirty data list and a clean one and I'm trying to add the info from the clean list to the cells in the dirty one. Any help would be greatly appreciated
EggHeadCafe - Software Developer Portal of Choice A Brief Synopsis of C# Class and Method Modifiers http://www.eggheadcafe.com/tutorials...s-of-c-cl.aspx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replacing an empty cell | Excel Discussion (Misc queries) | |||
| Replacing data in a cell | Excel Discussion (Misc queries) | |||
| find cell with matching text, then reference cell in same row | Excel Worksheet Functions | |||
| Replacing value in cell with answer of same cell | Excel Worksheet Functions | |||
| Matching data and linking it to the matching cell | Links and Linking in Excel | |||
Linear Mode
