title: Compare column A sheet 1 and compare column B sheet 2 and if duplicate found, copy and return value on column B sheet 1 from column C sheet 2?
body: <p>I am looking for a formula -</p>
  <p>Compare column A sheet 1 and compare column B sheet 2 and if duplicate found, copy and return value on column B sheet 1 from column C sheet 2?</p>
  <p>Hope that make sense.</p>
  <p>Thanks is advance.</p>