Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to consolidate data from another workbook
basically, the task at hand is to have a formula in workbook 'a' search
workbook 'b' for specific data, and total up a sum. sort of. what's happening is the workbook a is a large list of different customers, and workbook b is a list of sales orders, more or less. Now, both are huge documents, and some significant issues lie in the way that the sales orders are recorded (ie: while customer 'john smith' exists in both workbooks, workbook a will have 'john smith' and b might have 'j smith' or some other sort of variation) I was trying to run an 'if' statement for this, and it makes sense in programming language (at least to me) but because i've got text based values, it returns false. the shear number of different data types i need to pull is making it unable to do a vlookup. since the sales orders list multiple products, and the workbook a is showing the product family. i have no idea if this even makes sense to explain. but if anyone gets what i'm after, any help would be great. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to consolidate data from another workbook
You want to match some data on one sheet with corresponding data on
another sheet. For this to happen, you need to have exact matches on both sheets. John Smith will not match with J Smith without some manipulation of the data, and you may well find that there are many variations in the spelling of this name, so that could take some time. It is very common to have a unique customer number, rather than rely on name, and then this could be the data field on which to search. As you are going to have to manipulate the data in some way, you might think about setting up a unique customer number now to make it easy for yourself in the future. Hope this helps. Pete On Nov 8, 11:07 pm, rshardisty wrote: basically, the task at hand is to have a formula in workbook 'a' search workbook 'b' for specific data, and total up a sum. sort of. what's happening is the workbook a is a large list of different customers, and workbook b is a list of sales orders, more or less. Now, both are huge documents, and some significant issues lie in the way that the sales orders are recorded (ie: while customer 'john smith' exists in both workbooks, workbook a will have 'john smith' and b might have 'j smith' or some other sort of variation) I was trying to run an 'if' statement for this, and it makes sense in programming language (at least to me) but because i've got text based values, it returns false. the shear number of different data types i need to pull is making it unable to do a vlookup. since the sales orders list multiple products, and the workbook a is showing the product family. i have no idea if this even makes sense to explain. but if anyone gets what i'm after, any help would be great. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I consolidate multiple worksheet files into one workbook | Excel Discussion (Misc queries) | |||
Consolidate workbook template | Excel Discussion (Misc queries) | |||
Consolidate multiple worksheets in a workbook into one | Excel Discussion (Misc queries) | |||
Consolidate multiple spreadsheets into a single workbook | Excel Discussion (Misc queries) | |||
consolidate data into one workbook | Excel Discussion (Misc queries) |