matching and updating 2 sheets data

[reemref]

Hi,

i want to compare and update between 2 sheet data with condition.

i wanted to update sheet 1 data with sheet 2 data. please see the attachment

i have attached a worksheet there u can get a rough idea of what i want to do. please help

Rafeeq

[reemref]

please guys please help me to solve this issu. i am finding very difficult without this