Need to copy and match data from one workbook to another workbook
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. |
Need to copy and match data from one workbook to another workbook
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. |
All times are GMT +1. The time now is 05:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com