title: compare values in 2 excel sheets
body: <p>I am looking for a formula to look at any value in Column D on Sheet1 and compare it with any value in Column D on Sheet2 and if there is a match put TRUE in Column H in the row of the match of Sheet2. The Data does not match per cell# such as D3 Sheet1 = D3 Sheet2. It might be D3 Sheet1 = D2487 Sheet2.</p>