Greetings, i am looking help on following. I have 4 columns in worksheet 1 -
Name, Dept, Salary advance & Salary to be paid, in worksheet 2, I have list
of names. Every month i need to take worksheet 2 containing list of names and
search in worksheet-1, if i find a match need to look at Salary advance
column and adjust this amount in Salary to be paid.

Note:worksheet-1 & 2 contain more than 1000 entries.


Example:
Worksheet-1
Tom,Sales,$200,$2000
Bob,Sales,$0,$2500
Simon,Sales,$1000,$3000

Worksheet-2
Simon
Tom

Result :
Tom,Sales,$0,$1800
Bob,Sales,$0,$2500
Simon,Sales,$0,$2000

Thank you for your time in advance ....