Need to copy and match data from one workbook to another workbook
in [Functions]
|
Prev: Inserting a calculated field in a Pivot Table in Excel 2003
Next: How to convert 115:14 into hours? ( 115 stands for hrs, 14 is
From: clc_80 on 6 Apr 2010 18:29 I have one workbook that has book information such as book code, title and author. I have another workbook that has the ISBN Number and the amount of revenue that it has made I need to look up the revenue by ISBN number on the one sheet copy and paste it to a different sheet that has the rest of the book information. Is there an easier way to do this. I was thinking about the index, match formula but I can't get the formula to work. Any other suggestions? Any help is greatly appreciated.
From: "David Biddulph" groups [at] on 6 Apr 2010 18:41
Did you try VLOOKUP? -- David Biddulph "clc_80" <clc_80(a)discussions.microsoft.com> wrote in message news:6FD7E0DF-7543-405C-956B-D349FAFACFEF(a)microsoft.com... > I have one workbook that has book information such as book code, title and > author. > I have another workbook that has the ISBN Number and the amount of revenue > that it has made > I need to look up the revenue by ISBN number on the one sheet copy and > paste > it to a different sheet that has the rest of the book information. Is > there > an easier way to do this. I was thinking about the index, match formula > but I > can't get the formula to work. Any other suggestions? Any help is greatly > appreciated. |