| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to copy an image (or picture) from one workbook to a new sheetin another workbook | Excel Worksheet Functions | |||
| Search Data from one Workbook and copy it into another Workbook | Excel Discussion (Misc queries) | |||
| Copy Data from Workbook into specific Worksheet in other Workbook? | Excel Discussion (Misc queries) | |||
| copy excel workbook to new workbook without data | Excel Worksheet Functions | |||
| Copy data from one workbook to another workbook | New Users to Excel | |||
Linear Mode
