What Function can I use to get data from Sheet2 into Sheet1 based on
input on Sheet1? IF function won't work because tables will be several
hundred rows long. If a function can't be used, is there another way to
do it?

What I mean is if (Sheet 2 column A row 7) has a value of "10", and on
(Sheet 1 column A row 7) I enter "10", I would like "ABC Trucking" to
be entered in (Sheet 1 column B row 7) and I would like "3:00 PM" to be
entered in (Sheet 1 column E row 7), etc. See attached spreadsheets as
an example which should clarify what I mean. Thanks for your help.


+-------------------------------------------------------------------+
|Filename: Dispatch Database Test - Sheet 2.txt |
|Download: http://www.excelforum.com/attachment.php?postid=4496 |
+-------------------------------------------------------------------+

--
compconnj
------------------------------------------------------------------------
compconnj's Profile: http://www.excelforum.com/member.php...o&userid=32677
View this thread: http://www.excelforum.com/showthread...hreadid=524864