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