excel vlookup error

Hi
I have two sheets. The first sheet has the headers of:

(DATE)( ROUTE) (MANIFEST) (CUST#)(NAME)(DELIVERED)(PICKED
UP)(DIFFerence)          the second sheet has the colummn headers:
(CUST#) (CUSTOMER_NAME)(SLSMN_ID)( SALESMAN)

I am trying to get a formula or macro that will search the cust# in
sheet 2
then copy the field SLSMN_ID to a field or column in Sheet 1 for that
cust#.

 I was trying to do a vlookup formula-but I came up with this which is
pulling a salesman id# but not the correct #.

=INDEX(access_Plts.xls!salesid, MATCH(710,Sheet2!$A$1:$A$2613,),
MATCH("SLSMN_ID",Sheet2!$A$1:$D$1,))

Can anyone help me figure this out.  I thank you in advance for your
consideration.

Thanks
Lois