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.

When looking for the proper newsgroup to post your
question, you zigged where you should have zagged. Try
the Excel newsgroup.

numbers) and write a
cell or group of
truck # in A2 and
every piece of data
the repeated in
Show quoteHide quote

ASP and MS Access and Password Authentication
Windows XP SP2 & Frontpage
Shared border
FrontPage - creating a joint home page with links to 2 different p
Adding multiple checkbox values
Help! I just normalized my database
Background sound types or extensions.
Front Page & Netscape Compatability - Assistance Please
Changing the default Portrait Option When Printing
displaying results on web site in frontpage