From: clc_80 on
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
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.