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

Something like: http://tinyurl.com/5bk6g

Macshots Wrote:
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


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=275525

Hi!

It depends on what this is intended to be used for.

This is my interpretation of what you want.

Use data validation dropdown lists in column A so you can
pick from a list the truck #'s. If a particular driver #
and driver name are always associated with the same truck
# then you can use VLOOKUP formulas to get the driver #
and name.

Or, if any driver can use any truck then maybe all you
want are a series of dropdown pick lists.

Biff

-----Original Message-----
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
.