View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ross Cazaly Ross Cazaly is offline
external usenet poster
 
Posts: 1
Default 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