M
Macshots
How do I take data from a table (columns of names and numbers) and write a
formula so data from that table can appear in a specific cell or group of
cells.
Example (table contains three columns):
Column 1 Truck # Column 2 Driver # Column 3 Driver Name
(list of 15-20 rows for each column)
How do I write a formula in A2 that will populate the truck # in A2 and
their driver # in B2 and their name in c2? I don't need every piece of data
from the table in consecutive rows. Sometimes I need the repeated in
multiple rows.
formula so data from that table can appear in a specific cell or group of
cells.
Example (table contains three columns):
Column 1 Truck # Column 2 Driver # Column 3 Driver Name
(list of 15-20 rows for each column)
How do I write a formula in A2 that will populate the truck # in A2 and
their driver # in B2 and their name in c2? I don't need every piece of data
from the table in consecutive rows. Sometimes I need the repeated in
multiple rows.