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