title: Comparing two excel sheets and finding max value AND copying neighbor cell
body: <p>I have two sheets, with similar formatting but different values.</p>
  
  <p>Here's an example (real spreadsheet of course has more values)</p>
  
  <p>Sheet 1</p>
  
  <p>Temp  |   Year
  89    |   1979</p>
  
  <p>Sheet 2</p>
  
  <p>Temp  |   Year
  77    |   1998</p>
  
  <p>I want to compare the Temp Values and put the highest value in a 3rd sheet, and copy the neighboring year value into the neighboring cell in the 3rd sheet.  So what I have as a result in the 3rd sheet by using this formula: =MAX(Sheet1!B4,Sheet2!B4)
  is:</p>
  
  <p>89</p>
  
  <p>But what I'd like is (by referencing the value in the next column and placing it in next column on 3rd sheet):</p>
  
  <p>89  |  1979</p>
  
  <p>Does anyone have an idea how to do this? </p>
  
  <p>Thanks for your time,</p>
  
  <p>S</p>