Thank you very very much for the formula!


"Govind" wrote:

> Hi,
>
> Use
>
> =IF(ISERROR((VLOOKUP(A2,Sheet1!$A$2:$B$5,2,FALSE))),0,(VLOOKUP(A2,Sheet1!$A$2:$B$5,2,FALSE)))
>
>
> and copy it down.
>
> Here A2 is the cell where 'John' is in Worksheet 2.
>
> Regards
>
> Govind.
>
>
> PJS wrote:
>
> > Hi everyone.
> >
> > I am not sure which commands to use, can someone please show me how to
> > accomplish this?
> >
> > I have two different worksheets
> >
> > Worksheet 1 Worksheet 2
> > Name Total Name Total
> > Abe 3 John
> > Bob 4 Jane
> > Charlie 5 Bob
> >
> > I would like to compare the names in column A (worksheet 1) vs. the names in
> > colum A (worksheet 2), if they match, in this case Bob, return the value 4 in
> > worksheet 2. For John and Jane, since no matches are found, return the value
> > 0.
> >
> > Is this possible and what commands are needed?
> >
> > Thank you,
> >
> > Peter
>