Standard LOOKUP function.

After entering a Load #, the following formula can lookup the rest:

Date:
=LOOKUP(A2,[Book1.xls]Sheet1!$D$2:$D$1000,[Book1.xls]Sheet1!$A$2:$A$1000

Customer:
=LOOKUP(A2,[Book1.xls]Sheet1!$D$2:$D$1000,[Book1.xls]Sheet1!$C$2:$C$1000


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45972