Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Large Data File Consolidation...
I have been trying to find a way to consolidate data in two tables,
but can't seem to locate a good response. I have been toying with EXACT, VLOOKUP, HLOOKUP, and MATCH, but none seem to work for my issue. Two Files - Call them File A and File B File A and B both contain first name, last name, and date columns. I am trying to take the combined first name, last name, and date column from a row in File B as a single record, look for an exact match in File A, and if it finds one, return values in Coumns D, E, F back to File B on the same row. Can't do this manually as I have File B with almost 18,000 rows and File A with almost 10,000 rows. Any help would be greatly appreciated. Thanks Drew |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Large Data File Consolidation...
Send your files to me at dguillett1 @gmail.com with examples.
On Jan 25, 7:26*am, divrdrew wrote: I have been trying to find a way to consolidate data in two tables, but can't seem to locate a good response. *I have been toying with EXACT, VLOOKUP, HLOOKUP, and MATCH, but none seem to work for my issue. Two Files - Call them File A and File B File A and B both contain first name, last name, and date columns. I am trying to take the combined first name, last name, and date column from a row in File B as a single record, look for an exact match in File A, and if it finds one, return values in Coumns D, E, F back to File B on the same row. Can't do this manually as I have File B with almost 18,000 rows and File A with almost 10,000 rows. Any help would be greatly appreciated. Thanks Drew |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Large Data File Consolidation...
On Jan 25, 10:54*am, Don Guillett wrote:
Send your files to me at dguillett1 @gmail.com with examples. On Jan 25, 7:26*am, divrdrew wrote: I have been trying to find a way to consolidate data in two tables, but can't seem to locate a good response. *I have been toying with EXACT, VLOOKUP, HLOOKUP, and MATCH, but none seem to work for my issue. Two Files - Call them File A and File B File A and B both contain first name, last name, and date columns. I am trying to take the combined first name, last name, and date column from a row in File B as a single record, look for an exact match in File A, and if it finds one, return values in Coumns D, E, F back to File B on the same row. Can't do this manually as I have File B with almost 18,000 rows and File A with almost 10,000 rows. Any help would be greatly appreciated. Thanks Drew Answered privately. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidation of Data from more than one worksheet file | Excel Worksheet Functions | |||
Very large file - simple data | Excel Discussion (Misc queries) | |||
Importing (too) large data file | Excel Discussion (Misc queries) | |||
How do I eliminate every fourth row of data in a large file? | Excel Discussion (Misc queries) | |||
large data file problems - pivot table with vba | Excel Programming |