Need to copy and match data from one workbook to another workbook

C

clc_80

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to copy files from Onedrive account to another 2
Designate font as italic of another 0
trouble with (complicated) vlookup searching another workbook 2
Referencing relative to a formula reference 3
Combining two sheets of data into one and sorting by value - using macros 5
Dumb question alert! What program to use? 0
Index Match & #values 0
Outlook meeting location auto prompts with a suggestion list - need to disable 0

Top