Re: excel vlookup error

Lois,
If the CUST# is in column D of sheet1, and in sheet2 you have CUST# in
column A and SlLSMN_ID in column C then this should work in row 2.
=VLOOKUP(D2,Sheet2!A:C,3,FALSE)
if you want to put the formula in before you put in the CUST# and stop the
errors you could use
=IF(ISERROR(VLOOKUP(D2,Sheet2!A:C,3,FALSE)),"",VLOOKUP(D2,Sheet2!A:C,3,FALSE
))
to replace any errors with a space.
Hope this helps,
Barbara

"lparsons" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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