Lookups???

K

KevinUPS

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?
 
K

KevinUPS

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
 
S

Spiky

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 sheet1
Click to expand...

For any particular lookup, is there only one unique answer or could
there be multiple answers?
 
Top