View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CarisaJo CarisaJo is offline
external usenet poster
 
Posts: 1
Default Take a range of data and copy to another by matching a unique id

I have one worksheet that holds data that I need in another worksheet. I do
not want to copy and paste, because all of the data may not match up. Is
there a formula that will match the data from the two tables using a unique
identifier existing in both tables and only update those records?
Thanks.