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?