EXCEL: Use VLOOKUP to Match Data from two Different Sheets
=VLOOKUP(A2;Sheet1!A:D;4;FALSE)
Find match of the A2 from Sheet1 in column A of Sheet2, return value of column D of Sheet2. Number 4 is index of column D in sheet2
=IF(ISERROR(VLOOKUP(A2; Sheet1!A:D; 4; FALSE)); "No Match"; D2 - VLOOKUP(A2; Sheet1!A:D; 4; FALSE))
if A2 is not in the sheet2 then “No Match”
if D2 from sheet1 = D from match in sheet2 then 0
if D2 from sheet1 <> D from match in sheet2 then display difference in values (X-Y)