Hi cpegram,

try this in new excel spreasheets 1 & 2 (As a test)

Spreadsheet 1

A1 truck Numbers

A2 to A7 Enter random truck numbers

B1 Route Numbers

B2 to B7 Enter random route numbers

Sreadsheet 2

A1 Truck Numbers

A2 to A7 Enter Your list of random truck numbers

B1 Route Numbers

B2 Enter this and drag down to B7


Code:
--------------------


=IF(ISNA(VLOOKUP(A2,Sheet1!$A$2:Sheet1!$B$7,2,FALS E)),"0",VLOOKUP(A2,Sheet1!$A$2:Sheet1!$B$7,2,FALSE ))


--------------------



Will this help?


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=376568