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.