Formula to Extract Data from a Table
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 #'s Column 2 Driver #'s Column 3 Driver Names
(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.
--
Macshots
|