Vlookup and replace cell content from sheet2 to sheet1

[satish78]

Hi

I need the formula to vlookup and match domains from sheet2 ColumnC to sheet1 ColumnG and copy the sheet2 columnA, ColumnB, and ColumnC contents to sheet1 ColumnA, ColumnB, ColumnC.

I attached the sample worksheets.

http://www.filedropper.com/vlookup1

result will be
http://www.filedropper.com/vlookup2

 

[satish78]

I mean not to replace cell content.
I want copy cell content from sheet2 to sheet1.