|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 15th, 2008, 03:44 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookups???
I have two sheets of data that both have multiple columns and multiple rows.
I am trying to populate the 1st sheet (one column / multiple rows) with data from the second sheet (one column / multiple rows). An example… Sheet 1 Sheet 2 A B C D E F "G" A B C D E F G I am wanting to populate “G” in the 1st sheet with the data when it matches from sheet 2. The first table has roughly 6K rows of information and the second table has about 276K… So there are instances when there is not a match. Is this a lookup? 
|
|
#2
September 15th, 2008, 03:51 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookups???
Maybe better explained like this...
Sheet 1 Sheet 2 A Date A Date B FltNumber B FltNumber C Org City C Org City D Dest City D Dest City K Blk Hours K Populate from a lookup??? On sheet 1 "KevinUPS" wrote: I have two sheets of data that both have multiple columns and multiple rows. I am trying to populate the 1st sheet (one column / multiple rows) with data from the second sheet (one column / multiple rows). An example… Sheet 1 Sheet 2 A B C D E F "G" A B C D E F G I am wanting to populate “G” in the 1st sheet with the data when it matches from sheet 2. The first table has roughly 6K rows of information and the second table has about 276K… So there are instances when there is not a match. Is this a lookup?
|
|
#3
September 15th, 2008, 07:50 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookups???
On Sep 15, 9:51 am, KevinUPS
wrote: Maybe better explained like this... Sheet 1 Sheet 2 A Date A Date B FltNumber B FltNumber C Org City C Org City D Dest City D Dest City K Blk Hours K Populate from a lookup??? On sheet 1 "KevinUPS" wrote: I have two sheets of data that both have multiple columns and multiple rows. I am trying to populate the 1st sheet (one column / multiple rows) with data from the second sheet (one column / multiple rows). An example Sheet 1 Sheet 2 A B C D E F "G" A B C D E F G I am wanting to populate G in the 1st sheet with the data when it matches from sheet 2. The first table has roughly 6K rows of information and the second table has about 276K So there are instances when there is not a match. Is this a lookup? For any particular lookup, is there only one unique answer or could there be multiple answers?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
