Did you try VLOOKUP?
--
David Biddulph


"clc_80" wrote in message
...
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.