Check if data in Sheet1 matches with Sheet2 and then update sheet1

Hi All

I got stuck in a problem. Please see attached the workbook. There is data present in Sheet1 and Sheet2.I want to check the following things:

1. For each record in Sheet1, If "F" column stores "list work" then don't do anything and move to step 2.

2. Check for each record, If data in "F" column of Sheet1 matches with "H" column data of sheet2 then store the value of corresponding "E" column of sheet2 in "G" column of sheet1.

3. If it doesn't match then leave that record and move to next record of sheet2.
I tried writing the following code but it doesn't work:

Please Login or Register  to view this content.

Can anyone please help me in this?

Thanks

Hi Guys
I am getting type mismatch error at the red line in the following code:

Please Login or Register  to view this content.

sorted guys. I was writing rows n columns values other way around. Thanks anyway.