Lookups???

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

 

[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

 

[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

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